Vlookup Error #N/A
 

I have tried to use
=VLOOKUP(MAX(B2:B16),A2:A16,1,FALSE)
where area B2:B16 contains numerical Data sorted Decending
and Area A2:A16 contains Names,
I want the cell containing the above formula to show the name of the person
having the highest points in that list, knowing the names are not sorted
alphabetically.
but I keep getting the final answer as:
#N/A
any suggestions what's wrong here? is there a better way to show the name of
the person having the highest points other than the following function?
=INDEX(A2:A16,1,1)

Vlookup Error #N/A
 

=INDEX(A2:A6,MATCH(MAX(B2:B6),B2:B6,0))

Regards,
Stefi

€žAbdul€� ezt Ã*rta:

I have tried to use
=VLOOKUP(MAX(B2:B16),A2:A16,1,FALSE)
where area B2:B16 contains numerical Data sorted Decending
and Area A2:A16 contains Names,
I want the cell containing the above formula to show the name of the person
having the highest points in that list, knowing the names are not sorted
alphabetically.
but I keep getting the final answer as:
#N/A
any suggestions what's wrong here? is there a better way to show the name of
the person having the highest points other than the following function?
=INDEX(A2:A16,1,1)

Vlookup Error #N/A
 

You can't use VLOOKUP in that way - the lookup value must be part of the
table and must be in the left-most column of the table. You will have to use
an INDEX/MATCH function.

Hope this helps.

Pete

"Abdul" wrote in message
...
I have tried to use
=VLOOKUP(MAX(B2:B16),A2:A16,1,FALSE)
where area B2:B16 contains numerical Data sorted Decending
and Area A2:A16 contains Names,
I want the cell containing the above formula to show the name of the
person
having the highest points in that list, knowing the names are not sorted
alphabetically.
but I keep getting the final answer as:
#N/A
any suggestions what's wrong here? is there a better way to show the name
of
the person having the highest points other than the following function?
=INDEX(A2:A16,1,1)

Vlookup Error #N/A
 

=VLOOKUP(MAX(B2:B16),A2:B16,2,FALSE)



On Nov 4, 4:42*pm, Abdul wrote:
I have tried to use
=VLOOKUP(MAX(B2:B16),A2:A16,1,FALSE)
where area B2:B16 contains numerical Data sorted Decending
and Area A2:A16 contains Names,
I want the cell containing the above formula to show the name of the person
having the highest points in that list, knowing the names are not sorted
alphabetically.
but I keep getting the final answer as:
#N/A
any suggestions what's wrong here? is there a better way to show the name of
the person having the highest points other than the following function?
=INDEX(A2:A16,1,1)

Vlookup Error #N/A
 

Won't work. See my comments and Stefi's solution.

Pete

On Nov 4, 12:24*pm, muddan madhu wrote:
=VLOOKUP(MAX(B2:B16),A2:B16,2,FALSE)