# Thread: Help on Lookup Formula

1. ## Help on Lookup Formula

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,  Reply With Quote

2. not at all sure, but:
=IFERROR(LOOKUP(1,1/(A\$3:A\$13="x"),C\$3:C\$13),"")  Reply With Quote

3. Originally Posted by p45cal 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  Reply With Quote

4. 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.  Reply With Quote

5. Originally Posted by Hercules1946 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  Reply With Quote

6. Glad you found a solution!  Reply With Quote

#### Posting Permissions

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