?
Solved

Problem with VLOOKUP

Posted on 2016-07-29
7
Medium Priority
?
60 Views
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,

B.
VLookup-Problem.xlsx
0
Comment
Question by:Bright01
7 Comments
 
LVL 54

Accepted Solution

by:
Rgonzo1971 earned 1400 total points
ID: 41734255
Hi,

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

Open in new window

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

Open in new window

Regards
0
 
LVL 33

Assisted Solution

by:Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj) earned 200 total points
ID: 41734261
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
 
LVL 33

Expert Comment

by:Subodh Tiwari (Neeraj)
ID: 41734264
I think Rgonzo got your desired output in I5. Right?
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 34

Assisted Solution

by:Rob Henson
Rob Henson earned 400 total points
ID: 41734280
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 Comment

by:Bright01
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.

B.
0
 

Author Closing Comment

by:Bright01
ID: 41734291
Great job!  Thanks for the help!

B.
0
 
LVL 33

Expert Comment

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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

830 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