?
Solved

Problem with VLOOKUP

Posted on 2016-07-29
7
Medium Priority
?
58 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 52

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 32

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 32

Expert Comment

by:Subodh Tiwari (Neeraj)
ID: 41734264
I think Rgonzo got your desired output in I5. Right?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 33

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 32

Expert Comment

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

Featured Post

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

Question has a verified solution.

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

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

777 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