Excel Lookup Function, need help!

ouch_mybrain_ used Ask the Experts™
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.
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:

Oops, try this instead:



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