Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP
Okay I have figured out how to do a VLOOKUP in a column of some 250 entries
and it returns the highest value in the column, however I would also like to have it return the numbers in the column to the left of the highest value found by the VLOOKUP. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP
Hi,
I suspect you will need to use INDEX and MATCH functions together, as a VLOOKUP cannot do what you want. Have a look at this to see the technique: http://www.contextures.com/xlFunctions03.html Look at the "INDEX / MATCH -- Example" for starters. It's a little bit mind bending the first time you look at it but the last two sentences in this paragraph I have referenced explain the two separate steps well. Cheers, Matt "Weather-Check" wrote: Okay I have figured out how to do a VLOOKUP in a column of some 250 entries and it returns the highest value in the column, however I would also like to have it return the numbers in the column to the left of the highest value found by the VLOOKUP. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |