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
Bright01Asked:
Who is Participating?
 
Rgonzo1971Connect With a Mentor Commented:
Hi,

pls try
=VLOOKUP(D5,N12:O15,2)

Open in new window

and
=VLOOKUP(E5,P12:Q15,2)

Open in new window

Regards
0
 
Subodh Tiwari (Neeraj)Connect With a Mentor Excel & VBA ExpertCommented:
In H2, you should use the following formula...
=VLOOKUP(D5,N12:O15,2,0)

Open in new window


What are you trying to return in I5 based on E5? What is your expected output in I5?
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
I think Rgonzo got your desired output in I5. Right?
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Rob HensonConnect With a Mentor 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
 
Bright01Author 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
 
Bright01Author Commented:
Great job!  Thanks for the help!

B.
0
 
Subodh Tiwari (Neeraj)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.

All Courses

From novice to tech pro — start learning today.