How to Look up Based on Multiple Conditions [SOLVED]

[Pofski]

Hi,


i've been trying to use the guidelines showed here http://chandoo.org/wp/2010/11/02/multi-condition-lookup/ to do a filtering depending on 2 different criteria.


But for some reason i keep getting the #value result, no matter which way i use.

Is it that these different possibility's only work if the result is a number?


Best regards

 

[DaveTurton]

Could you post an example of your data please?

Thanks

 

[Pofski]

https://docs.google.com/file/d/0B0naOkYo4pCmck9GZTJVQkFjNGM/edit?usp=sharing


So what the point is that i am trying to reach, is that by selecting one of the checkboxes, and a plant that the column requestnumber is shown if it meets the 2 criteria's (so C3 and F3). I need to have a list with the request numbers underneath each other.

 

[NARAYANK991]

Hi Pofski ,


Try this :


=INDEX(Table1[RequestNumber],SMALL(IF(Table1[Status]=$F$3,IF(Table1[Plants]=$C$3,ROW(Table1)-MIN(ROW(Table1))+1)),ROW(A1)))


entered as an array formula , using CTRL SHIFT ENTER , and copy down.


Narayan

 

[Pofski]

Excellent


Thnx again Narayan