New to Excel...need help with formula

[brentgrigsby]

I have an Excel spreadsheet that I need help on.
I just need the general code and I can import it from there...
If my assistant enters the letter XP, it grabs a particular cell that has XP cost and multiplies it by the amount of gallons used in another cell.
If however, my assistant uses only X, it grabs a different call that has X cost and multiplies it by the amount of gallons used in another cell.

Don't know how to post the Excel spreadsheet, which would probably help you see the flow.

Thank you.

Regards,
Brent

 

[brentgrigsby]

Sheetspread, you have done it.

Awesome work!! wow.

Thank you a million.

You guys are brilliant.