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.
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.
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!
Ola Junior and Denis solved the problem with this formula:
= INDEX (A $ 4: A $ 11; MATCH (MAX (B5: B11); B $ 4: B $ 11; 0))
Hugs and very grateful.