# 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,

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

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

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.

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

6. Glad you found a solution!

#### Posting Permissions

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