Solved

Problem with VLOOKUP

Posted on 2016-07-29
7
48 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 49

Accepted Solution

by:
Rgonzo1971 earned 350 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 29

Assisted Solution

by:Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj) earned 50 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 29

Expert Comment

by:Subodh Tiwari (Neeraj)
ID: 41734264
I think Rgonzo got your desired output in I5. Right?
0
Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

 
LVL 32

Assisted Solution

by:Rob Henson
Rob Henson earned 100 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 29

Expert Comment

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

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

770 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