Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Minimum value look up
I have a giant list of PNs I've complied from several different quotes
from the vendor for 26 FGs. I need a formula to return the minimum value from the list for a look up against specific PNs. So in the formula cell I need to sort of vlookup the value I'm interseted in from the list, but return the lowest found value. Help? -Steven M. Britton |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Minimum value look up
Try this array formula** :
A1:A10 = pns B1:B10 = numeric values D1 = pn to look up =MIN(IF(A1:A10=D1,B1:B10)) ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER) -- Biff Microsoft Excel MVP " wrote in message ... I have a giant list of PNs I've complied from several different quotes from the vendor for 26 FGs. I need a formula to return the minimum value from the list for a look up against specific PNs. So in the formula cell I need to sort of vlookup the value I'm interseted in from the list, but return the lowest found value. Help? -Steven M. Britton |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Minimum value look up
Perfect Thx
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Minimum value look up
You're welcome!
-- Biff Microsoft Excel MVP " wrote in message ... Perfect Thx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Minimum Value | Excel Worksheet Functions | |||
How to lookup the minimum, 2nd minimum and 3rd minimum......... | Excel Worksheet Functions | |||
minimum | Excel Worksheet Functions | |||
Minimum but One?? | Excel Worksheet Functions | |||
Minimum Value | Excel Worksheet Functions |