| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to lookup a value in excel?
Does anyone know how to lookup a value in following example?
[A1] 1 [B1] 45 [A2] 2 [B2] 90 [A3] 3 [B3] 88 [A4] 4 [B4] 56 I would like to look up the highest value under B colume, such as 90 in cell B2 in this case, and return the value of 2 from cell A2 into C1 cell. Does anyone have any suggestion? Thank you very much Eric |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel file with hyperlinks takes a long time to open over the network | Links and Linking in Excel | |||
| Excel lookup macro | Excel Discussion (Misc queries) | |||
| Multiple Excel versions. | Excel Discussion (Misc queries) | |||
| excel cell lookup file on harddrive | Excel Discussion (Misc queries) | |||
| Lookup Access data in Excel | Excel Worksheet Functions | |||
Threaded Mode
