Hello everyone,
I have a spreadsheet of sponsors for a golf tournament that I'm helping with, and would like to create a list of everyone who needs to remit payment, under their level type, and how much they owe.
I've attached a workbook with the the following sheets: List of sponsors, What I want to create with a formula, and a vlookup reference sheet.

GolfSpreadsheet_Help.xlsx

I've done a lot of Googling and cannot seem to find something that does what I would like. Can you help me?

Many thanks!!
Shannon