Referencing grid of different prices for different freelancers

I am trying to convert grid of information with different prices for different writers into a workable Airtable solution that I can use every week for payment to them.

Here is an example of the grid in the Excel file we’re currently using:

Screen Shot 2022-01-26 at 9.46.49 AM

So, say that Writer A writes a feature and Writer B writes two CD reviews. I need to be able to select the writers and the type of story and have the price come in automatically.

Let me know if there are more questions that need to be answered, Thanks!

ADDENDUM: OK, so the above grid exists in its own table. Then I have another table that I use to tally every week’s stories and payments. How should this first table be set up so the second table can reference the writer and the type of story to then receive the correct price?

Would Dynamic Variables do the trick for me? Or is there another solution?

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.