# VLOOKUP PROBLEM - Returns #N/A

1. ## VLOOKUP PROBLEM - Returns #N/A

All,

I have used VLOOKUP on numerous occasions but cannot figure out what I am doing wrong here. I have attached an extract of the sheet.

Essentially I have a calculation which produces a series of values in column O. I want to return (in cell E3) the corresponding value in column E to that in O.

The lookup value is located in E2. This look value will vary as it is return as the Maximum value found in column O.

All I get is #N/A

many thanks.

2. ## Re: VLOOKUP PROBLEM - Loosing will to live!

Hi
First 11,0491070083794 is not the max value of your range
Second Vlookup You can use this way
Use combination of MATCH and INDEX function

3. ## Re: VLOOKUP PROBLEM - Loosing will to live!

vlookup only returns values to the right of the lookup value (at least without array trickery). you need index and match
=INDEX(E7:E94,MATCH(E2,O7:O94,0))

4. ## Re: VLOOKUP PROBLEM - Loosing will to live!

Vlookup problem.xlsxHi

Have sorted for you.

Your lookup column needs to be the far left as in the attached

5. ## Re: VLOOKUP PROBLEM - Loosing will to live!

Thanks all, just learnt a lot.

Firstly I wasn't aware the lookup column needs to be the far left - bit of a schoolboy error that one,

Secondly, I am interested in the applications of the index and match tool. Why would I ever use vlookup in lieu of these?

6. ## Re: VLOOKUP PROBLEM - Returns #N/A

no good reason. people use it because they don't know about or understand index/match :-)

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1