# Problem with VLOOKUP

EE Pros,

I cannot get this simple VLOOKUP Formula to work...... Can you give me a little assistance with this?

Thank you in advance,

B.
VLookup-Problem.xlsx
Asked:
###### Who is Participating?

Commented:
Hi,

pls try
``````=VLOOKUP(D5,N12:O15,2)
``````
and
``````=VLOOKUP(E5,P12:Q15,2)
``````
Regards
0

Excel & VBA ExpertCommented:
In H2, you should use the following formula...
``````=VLOOKUP(D5,N12:O15,2,0)
``````

What are you trying to return in I5 based on E5? What is your expected output in I5?
0

Excel & VBA ExpertCommented:
I think Rgonzo got your desired output in I5. Right?
0

Finance AnalystCommented:
Your existing formula of:

=VLOOKUP(D5,N12:O15,O12:O15,2)

is very close to the syntax for LOOKUP, which should be

=LOOKUP(D5,N12:O15,O12:O15)

LOOKUP works similar to VLOOKUP but uses two separate ranges rather than one contiguous range. Where VLOOKUP relies on the reference column being the leftmost of the range, likewise HLOOKUP relies on reference being the top row; with LOOKUP the separate ranges can be either way round, ie the reference range can be to the right of the return range.

In addition, with LOOKUP the reference range can be a column and the return range can be a row.

Thanks
Rob H
1

Author Commented:
Regonzo nailed it!  Thank you.   And Nerraj, you had it right too but seconds "late to the party"......  Rob, your comment was educational and helpful for the future.

Thank you all for being such a great Team of professionals and helping out.

B.
0

Author Commented:
Great job!  Thanks for the help!

B.
0

Excel & VBA ExpertCommented:
You're welcome. Glad we could help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

## Already a member? Login.

All Courses

From novice to tech pro — start learning today.