Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
large & lookup function
hi everyone,
i have this data in sheet1 A B C D 1 10 sam a 2 9 ram b 3 8 dan c 4 7 mic d 5 7 ron e 6 6 rod f in sheet2 i would like to make lookup for the name of 5 larrgest Numbers as the following VLOOKUP(large(sheet1!$C$1:$E$6,A1),sheet1!$C$1:$E$ 6,2,FALSE) but the problem i have that when the largest 4 & 5 will not coem "mic" and "ron" because it have same value (7) only "ron" comes so is there any way to can use this furmula with some addition to can give the large 4th is mic and the large 5th is ron and thank for everyone give me the solution |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XL2002 - OFFSET function and LARGE function | Excel Worksheet Functions | |||
Query/Lookup in large list (text file) | Excel Discussion (Misc queries) | |||
Compound Lookup, Large/Small, Match... | Excel Worksheet Functions | |||
Large Index Match Lookup | Excel Worksheet Functions | |||
Finding LARGE value within range of lookup table | Excel Discussion (Misc queries) |