Excel 2010 Invoice to link to VLookup

[va247]

Hi

I'm needing some help/advice.

I have a table based on finder fees, whereby if someone refers me to a company they are paid a percentage of the qualification costs. For example
There are 3 workshops (ranging in price) where a person/company has referred me I give them between 10 & 30% of the overall workshop cost. What I want to do is link it to an invoice where I can put a company name and retrieve the workshop for it to automatically work out the finders fee to pay them.
Would it be easier just using If statements or data validation as opposed to VLookup tables??

Does that make sense?

Thanks