Results 1 to 2 of 2

Thread: Multiple criteria & hlookup formula help

  1. #1

    Multiple criteria & hlookup formula help

    Register for a FREE account, and/
    or Log in to avoid these ads!

    I'm doing some work with my clothing business, and am having trouble getting my head around what the best way of compiling the formula is. My head is telling my its a really simple one - but I just can't think of it - so any help would be much appreciated!
    If in column A, it says 'Accessories' & if in column B it says 'ffffff', then look for '9' between C1 & AK6 in column C. Then look horizontally for 'M'. Finally, present the value that is 25 rows down from this.

    If anyone needs a bit more clarity, please let me know
    thanks in advance!

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version
    This is ridiculously complex, I think you should revisit your design.

    This array formula seems to do it

    =IFERROR(IF(AND(A1="Accessories",B1="ffffff"),OFFSET(C1,MIN(IF($C$1:$K$6=9,ROW($C$1:$C$6)))+24,MATCH("M",INDEX($C$1:$K$6,MIN(IF($C$1:$K$6=9,ROW($C$1:$C$6))),0),0)-1),""),"Not found")
    Last edited by Bob Phillips; 2014-11-07 at 10:08 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts