On the Instructor Data worksheet, in cell J$3,$ use an IF function nested with Vlookup function to calculate the retirement matching amount for each instructor.

For an instructor who participates in retirement plan $($which is indicated in column I$),$ the retirement matching amount is calculated by multiplying his$/$her salary $($in column H$)$ by the retirement matching percentage. The retirement matching percentage is based on the instructor$$s rank specified in column D$.$ You can look for the retirement matching percentage and rank information in the range A$15$:B$17($you may want to turn relative cell reference into absolute cell reference$).$

For nonparticipating instructors, the retirement matching amount is $0.$

Apply the currency number format with $2$ decimal places to the results. Use the fill handle to copy the function down through the column.