| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Lookup(), VLookup
I have some data in one sheet similar to this:
100.0 2.2 200.0 3.1 300.0 1.9 400.0 2.8 On another sheet, I want to find the maximum value for column 2; i.e. 3.1 (which I can do) and then I want to find the corresponding value in column 1, i.e. 200.0. Can someone tell me how to get this? Thanks, Phil |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LOOKUP is working - but VLOOKUP is not | Excel Discussion (Misc queries) | |||
| Vlookup. Match. Lookup. Wtf? | Excel Discussion (Misc queries) | |||
| Double lookup without using vlookup? | Excel Worksheet Functions | |||
| IF, VLOOKUP & LOOKUP TABLE ON OTHER SHEET | Excel Discussion (Misc queries) | |||
| Getting #N/A from Vlookup when matching value exist in the lookup data range. | Excel Worksheet Functions | |||
Threaded Mode
