#N/A error with VLOOKUP function


A

Amer

I am trying to get the highest value in one column and return the
corresponding value of the same row using the following function:

=VLOOKUP(MAX(D5;D11;D17;D22;D28;D33;D38;D44);A1:D44;2;FALSE)

But I am receiving this error: #N/A

After checking the error, there is something wrong with the 'col_index_num'
part of the formula. This number should refer to column 'B' in my sheet.
 
Ad

Advertisements

M

Mike H

Hi,

I'm struggling to understand you formula so perhaps this will help

=INDEX(B:B,MATCH(MAX(A:A),A:A,0))

Finds the maximum value in column A and returns corresponding value in
Column B. It looks like you use ; and not , so make necessary changes.

Mike

Mike
 
A

Amer

Here is the new formula and the result is '0' !!!

=INDEX(B:B;MATCH(MAX(D5;D11;D17;D22;D28;D33;D38;D44);D:D;0))

Note that I am using Excel 2007. It changes the ',' to ';'.

(D5;D11;D17;D22;D28;D33;D38;D44) are selected cells in column 'D'. No need
for Excel to check the whole column.

Thanks for the help.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top