| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
maximum value received through vlookup
Sheet1
A B 5 4.5 5 5.5 5 5.4 5 8.6 5 1.2 6 5.6 6 6.4 6 5.6 8 5.6 9 1.0 sheet2 A B 5 i use =max(vlookup(sheet1:a1,sheet1a1:b11,2,0) for result 8.6 bcoz 8.6 is maximum no. for 5 but result is 4.5 bcoz it is first answer for it |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup - Is there a Maximum number of entries? | 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 | |||
| vlookup maximum cell range? | Excel Discussion (Misc queries) | |||
Threaded Mode
