What is the best method for solving the example equation with variable identifiers?

[stevencahoon]

The simple equation is in the example file with a brief description.  Table 1 will be hundreds of rows long, and there will be around 20 unique identifiers.  Thanks for the help.  -Steven

[#2]

@stevencahoon I've added two solutions for you in the attached workbook. One involves XLOOKUP, the other VLOOKUP. See which one works for you. Note also that I have used structured table references.

[#3]

Thank you so much @Riny_van_Eekelen! Great solution.