Function = VLOOKUP (MAX ($ B $ 5: $ B $ 11); $ A $ 5: $ A $ 11; 1; 0) Excel 2010

2

I'm using the function:

= VLOOKUP (MAX ($ B $ 5: $ B $ 11); $ A $ 5: $ A $ 11; 1; 0) in cell B23 in Excel 2010.

Result: # N / A!

Can anyone help me correct my formula?

Very grateful, Silvio.

    
asked by anonymous 25.10.2015 / 01:55

3 answers

1

You are looking for the maximum value of $ B $ 5: $ B $ 11 that is 118 in the $ A $ 5: $ A $ 11 and returning a value from column A also, in this case, has nothing at all. The function is not finding any reference. The # N / D error happens when Excel can not find what you requested.

I do not know what search you want to do, but just fine-tune the function.

The following is the structure of this function:

  

= VLOOKUP (search_value, table_array, index_number_column, range_lookup

     

search_value: the value to be found in the first column of the array.

     

table_array: The information table in which data is searched for.

     

index_column: The column number in the table_array to which the corresponding value should be returned.

     

interval_search: This is a logical value that specifies whether you want to find an exact match or an approximate match. If TRUE or unspecified, an approximate match is returned

     

Source: link

Generally, the table_array is not just a column, as we look in the first column, but to return another column later.

    
02.11.2015 / 22:47
0

Hello, change all the ";" by ',' to see if it works correctly!

Friend, making a correction, try to use the PROCV function instead of the one you are using, I believe it's a question of language! (so I asked to change the signs!

    
25.10.2015 / 02:39
0

Ola Junior and Denis solved the problem with this formula:

= INDEX (A $ 4: A $ 11; MATCH (MAX (B5: B11); B $ 4: B $ 11; 0))

link

Hugs and very grateful.

    
05.11.2015 / 15:26