Multiple Variables to determine output

Hi,
I’m struggling to figure this out. I have two columns (currently Status Columns) column 1 is a list if locations, column 2 is a list of positions worked across all the sites.
What I’d like to do is populate a third column with the pay rate based on the selections made for each site & position. There could be as many a 7 - 10 sites and a fixed set of 5 positions worked. The pay rate can vary at each location and the same person may work multiple positions.
Any Help would be greatly appreciated.