Hi, I might be explaining this poorly.
I have a column with countries and a column with staff level. On a separate tab I have a pivot table of rates for each country/staff level. Can I create a formula that says, if this country and this staff level, then the correct rate will pull from the pivot table?
Bookmarks