One try ..

Assuming this table is in A1:F4
Red Green Blue Yellow Orange
PET 6 8 14 3 2
OAK 5 6 7 8 12
SJC 2 7 11 8 5

and this "criteria range" is in A6:D6
PET Red Blue Yellow

Put in say, E6:

=MIN(TRANSPOSE(OFFSET($A$1,MATCH(A6,A:A,0)-1,MATCH(B6:D6,B1:F1,0))))

Array-enter the formula,
i.e. press CTRL+SHIFT+ENTER
instead of just pressing ENTER

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Steve R" wrote in message
...
I am looking for a formula to return the minimum value from a table
(below)

Red Green Blue Yellow Orange
PET 6 8 14 3 2
OAK 5 6 7 8 12
SJC 2 7 11 8 5

If the following lookup info is entered into 4 cells(below)

PET Red Blue Yellow - The value "3" is returned since it is the minimum
value in the "PET row" of the 3 items listed

Thanks for any help
Steve