Help on Lookup Formula

ludjaybouffard

New member
Joined
Jul 9, 2015
Messages
3
Reaction score
0
Points
0
Good Morning/Afternoon whever you are!

In short i want this
IFERROR(LOOKUP(2,1/A$3:A$13="x"),C$3:C$13),0) to be able to ignore the blank cell!

But it keeps giving me a result of 0 because it keeps getting the first cell of the list regardless if its blank or not!

This is my first post so i cannot give you a visual...

Thanks,


 

Attachments

  • Spreadsheet Preview.PNG
    Spreadsheet Preview.PNG
    41 KB · Views: 30
not at all sure, but:
=IFERROR(LOOKUP(1,1/(A$3:A$13="x"),C$3:C$13),"")
 
not at all sure, but:
=IFERROR(LOOKUP(1,1/(A$3:A$13="x"),C$3:C$13),"")

That wouldn't work but I figured it out

it would be IFERROR(LOOKUP(2,1/((A$3:A$13="x")*(C$3:C$13<>"")),C$3:C$13),0)

and that works perfectly

 
Another possibility:

=INDEX(C$3:C$13,MATCH(TRUE,INDEX(A$3:A$13="x",0),0))

I think the problem with LOOKUP is that a result vector is being used, and with multiple values matching the lookup value its unable to return one value from the result vector.
 
Last edited:
Another possibility:

=INDEX(C$3:C$13,MATCH(TRUE,INDEX(A$3:A$13="x",0),0))

I think the problem with LOOKUP is that a result vector is being used, and with multiple values matching the lookup value its unable to return one value from the result vector.

The reason I am using a vector is because I need to search from bottom to top.

But like I mentioned above I figured it out and it works like a charm

Thank you for your suggestion!
 
Back
Top