Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup #N/A Error | Excel Worksheet Functions | |||
vlookup error | Excel Discussion (Misc queries) | |||
vlookup error!! | Excel Worksheet Functions | |||
VLOOKUP ERROR | Excel Discussion (Misc queries) | |||
vlookup error | Excel Worksheet Functions |