Solved

# Problem with VLOOKUP

Posted on 2016-07-29
53 Views
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
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

LVL 51

Accepted Solution

Rgonzo1971 earned 350 total points
ID: 41734255
Hi,

pls try
``````=VLOOKUP(D5,N12:O15,2)
``````
and
``````=VLOOKUP(E5,P12:Q15,2)
``````
Regards
0

LVL 31

Assisted Solution

Subodh Tiwari (Neeraj) earned 50 total points
ID: 41734261
In H2, you should use the following formula...
``````=VLOOKUP(D5,N12:O15,2,0)
``````

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

LVL 31

Expert Comment

ID: 41734264
I think Rgonzo got your desired output in I5. Right?
0

LVL 33

Assisted Solution

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

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

ID: 41734291
Great job!  Thanks for the help!

B.
0

LVL 31

Expert Comment

ID: 41734469
You're welcome. Glad we could help.
0

## Featured Post

Question has a verified solution.

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

### Suggested Solutions

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associateâ€¦
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calculâ€¦
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
###### Suggested Courses
Course of the Month6 days, 8 hours left to enroll

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

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