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

With F1 value, look at A, if match or partial match return B 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
Calculating a Formula Subject to a Maximum and Minimum Value 2
modified vlookup help 5
Lookup returning wrong results 0
minimum value without zero 2
Get a row number of range where a value is between minimum and max 2

Top