How do I find a value in a table based on other criteria

[dinonz1965]

I'm trying to find a suitable formula that looks at two cells (J3 and V3) in Sheet 1 (a person's employment grade (e.g. 18) and their performance percentage e.g. 92.5%), finds those values in a table on Sheet 2 and then places the corresponding value from that table in Sheet 1 at cell Z3.

Any help would be greatly appreciated.

[JBeaucaire]

Try this in Z3:

=INDEX(IMAScales,MATCH(J3,Grade,0),MATCH(V3*100,IMAPercentage,1))

This matches EXACT percentages in the IMAPercentage range. If you want it to "round down", change the last parameter 0 to 1.

[dinonz1965]

Thank you JBeaucaire, the formula has worked a treat.