Thread: Is this VLookup Function?

Hi,

I have a feeling there is an easy way to do this, but I can't quite figure it out. Basically I enter a number of tournaments, and depending on which tournament and where I position I will earn differing amounts of money.

I have 2 worksheets, one called "Results" the other called "Backup".

On Backup I have a number of different entries. For each entry, there is a "tournament name", an "entry price" cell and a "fee" cell. Then there are Results depending on whether I come 1st, 2nd or 3rd.

On the results sheet, I want to be able to Type in the tournament name, and put my position and for it to work out the entry price, fee and then the results if I'm 1st, 2nd or 3rd - if I am none of those I need to return 0.

Hopefully someone can help?

Thanks
Andrew

Um, not really as I've not made it yet. If you really need something I can put it together though?