Minimum value look up

S

steven.britton

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
 
T

T. Valko

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select minimum with duplicate values to return column headings 3
Return corresponding information with minimum value 2
Calculating a Formula Subject to a Maximum and Minimum Value 2
Look up one value and return multiple corresponding values 2
Lookup Across Multiple Rows / Columns 5
Vlookup and return the value from the look up value sheet 1
VLOOKUP CONDITION TO RETURN BLANK CELL WHERE LOOKUP VALUE IS NOT IN TABLE ARRAY 3
How can I assign a value to a cell without putting a formula in it 4

Top