Multiple Look Ups to return an info from a table

[pleasesmile]

Hi,

I want the formula to look at cell B28 then D28 to determine what to put in cell E28 based on the 2 lookups and the data in cells B45:G49

Thank you,
PS

[Pete_UK]

Put this in E28:

=INDEX($C$46:$G$49,MATCH(B28,$B$46:$B$49,0),MATCH(D28,$C$45:$G$45,0))

then copy down.

Hope this helps.

Pete

[pleasesmile]

Perfect!

Thanks so much.