Formula Help

  • Thread starter Thread starter Dimitri
  • Start date Start date
D

Dimitri

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
"".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula required 2
Countif formula 2
CountIf formula problem when referencing a column. 4
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Reference Formula Help 1
Dynamic Sum Array Formula Input Help 3
Expiration Formula 2
Help needed 0

Back
Top