Hello:

On a seperate spredsheet I have created a synopsis but am having to enter
the information manually. Was hoping to do the following through a formula:

If Column A = 1 and Column B = $100,000 - on the seperate sheet would like a
formula to pick up ther data

Column A Column B
1 $100,000

Dimitri