Finding data from Table 1 with various variables to enter the correct value in table 2

Hello,

I have an issue that is bugging me and I've added an example of what I need help with.

I want to look up the data in Table 1 to enter the correct values in Table 2. What is the easiest way of doing this?

Is there a formula to do this?

I have attached a screenshot and the spreadsheet file

Can anyone solve this for me?

Thanks

Try in 'H4' (copy across & down);

Formula:

Please Login or Register  to view this content.