Column H5

=INDEX($C$5:$C$25,MATCH(G5,$B$5:$B$25,FALSE),MATCH($H$4,$A$5:$A$25,FALSE))
=INDEX($C$5:$C$25,MATCH(G6,$B$5:$B$25,0),MATCH($H$4,$A$5:$A$25,0))
=INDEX($C$5:$C$25,MATCH(G7,$B$5:$B$25,0),MATCH($H$4,$A$5:$A$25,0))
=INDEX($C$5:$C$25,MATCH(G8,$B$5:$B$25,0),MATCH($H$4,$A$5:$A$25,0))
=INDEX($C$5:$C$25,MATCH(G9,$B$5:$B$25,0),MATCH($H$4,$A$5:$A$25,0))
=INDEX($C$5:$C$25,MATCH(G10,$B$5:$B$25,0),MATCH($H$4,$A$5:$A$25,0))


Column I5

=INDEX($C$5:$C$25,MATCH(1,(G5=$B$5:$B$25)*($I$4=$A$5:$A$25),0))
=INDEX($C$5:$C$25,MATCH(1,(G6=$B$5:$B$25)*($I$4=$A$5:$A$25),0))
=INDEX($C$5:$C$25,MATCH(1,(G7=$B$5:$B$25)*($I$4=$A$5:$A$25),0))
=INDEX($C$5:$C$25,MATCH(1,(G8=$B$5:$B$25)*($I$4=$A$5:$A$25),0))
=INDEX($C$5:$C$25,MATCH(1,(G9=$B$5:$B$25)*($I$4=$A$5:$A$25),0))
=INDEX($C$5:$C$25,MATCH(1,(G10=$B$5:$B$25)*($I$4=$A$5:$A$25),0))

you will have to use the iserror formula if you want to get rid of the NA

the formula in column I is an array formula you will have to hit ctrl shift enter

I don't know why but column I needed a different formula

Attached Files

lookup two criteria 08-Nov-06 20-08-57.zip (5.3 KB, 154 views)

__________________
Dave
Please read the Forum Rules before posting!