Link to home
Start Free TrialLog in
Avatar of ouch_mybrain_
ouch_mybrain_

asked on

Excel Lookup Function, need help!

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.
Avatar of StephenJR
StephenJR
Flag of United Kingdom of Great Britain and Northern Ireland image

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))
ASKER CERTIFIED SOLUTION
Avatar of StephenJR
StephenJR
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ouch_mybrain_
ouch_mybrain_

ASKER

Perfect, thank you.