I'm need to write a formula based on information in a table - as an example:

High Performing Location Market Area Non-Market Area
New Location
1 $1,000,000 $750,000 $500,000
$200,000
2 800,000 600,000 300,000
100,000
3 550,000 400,000 200,000
50,000

I want to lookup the information in the top row and on the left column, then
multiply by a factor referenced in another cell. I have tried If,then with
vlookups and that's not working for me. What's the easiest way to accomplish
this?

I appreciate the help.

auntieb