=INDEX(F1:F100,MATCH(C1&C2,D1:D100&E1:E100,0))

it is an array formula, so commit with Ctrl-Shift-Enter.

--
HTH

Bob Phillips

"Gary H" wrote in message
...
Excel 2000

Is it possible to do a verticle looking comparing 2 columns rather than
just
1? Thanks.

Gary