| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup and get the maximum value
I have a col. A and Col. B
Column A Column B 10 44363 10 56634 20 26348 20 32688 If i enter "10" in column C, it should lookup in Col. A and return the max. value of Col. B (56634) Thru vlookup i am getting the only the first value only. Could someone help in this regard |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| maximum value received through vlookup | Excel Worksheet Functions | |||
| Looking up a maximum value that matches criteria. VLOOKUP? | Excel Worksheet Functions | |||
| Finding a maximum with VLOOKUP | Excel Discussion (Misc queries) | |||
| EXCEL MAXIMUM VALUE AND VLOOKUP NESTED? | Excel Worksheet Functions | |||
| vlookup for maximum value | Excel Worksheet Functions | |||
![Its me[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
