Excel Lookup Function, need help!

ouch_mybrain_
ouch_mybrain_ used Ask the Experts™
on
Dear Experts,

I need help writing what I would expect to be a simple VLookup, but i'm finding it difficult to grasp learning vlookups and need assistance.

Here is what I want logically in a cell:

If value in cell ### exists in the first column of range/array ### (only two columns wide), then show the value of the cell in the second column where the first cell was looked up.

If that doesn't make any sense, then I wouldn't be surprised. Please ask me for clarification.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
If your first cell is A1, and your range is B1:C10 then this should work:

=IF(ISNA(VLOOKUP(A1,B1:C10,2,FALSE)),""ISNA(VLOOKUP(A1,B1:C10,2,FALSE))
Oops, try this instead:

=IF(ISNA(VLOOKUP(A1,B1:C10,2,FALSE)),"",VLOOKUP(A1,B1:C10,2,FALSE))

Author

Commented:
Perfect, thank you.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial