Problem with VLOOKUP

Posted on 2016-07-29
Medium Priority
Last Modified: 2016-07-29
EE Pros,

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

Thank you in advance,

Question by:Bright01
LVL 54

Accepted Solution

Rgonzo1971 earned 1400 total points
ID: 41734255

pls try

Open in new window


Open in new window

LVL 35

Assisted Solution

by:Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj) earned 200 total points
ID: 41734261
In H2, you should use the following formula...

Open in new window

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

Expert Comment

by:Subodh Tiwari (Neeraj)
ID: 41734264
I think Rgonzo got your desired output in I5. Right?
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

LVL 35

Assisted Solution

by:Rob Henson
Rob Henson earned 400 total points
ID: 41734280
Your existing formula of:


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


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.

Rob H

Author Comment

ID: 41734288
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.


Author Closing Comment

ID: 41734291
Great job!  Thanks for the help!

LVL 35

Expert Comment

by:Subodh Tiwari (Neeraj)
ID: 41734469
You're welcome. Glad we could help.

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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.

Join & Write a Comment

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Manually copying shapes and their assigned macros one by one to a new location can be tedious, but if you use the Excel utility workbook attached to this article, the process will be much quicker and easier.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question