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

try this...

=if(sheet2!a1 = 1, b1,"")


this returns the value of b1 if there is a one otherwise it returns
"".


On Jun 26, 4:46*pm, Dimitri wrote:
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