IF Function (..........

M

MichelleS

How can I write an IF formula where I can type a NUMERIC value in one cell
and the adjacent cell automatically types TEXT selected from another Excel
Workbook?

Example: While in Workbook (Estimates.xls) in cell C22, I want to type an IF
formula -->
IF(B22=20,C22=text from another cell in another Workbook).

The other workbook is 'Prices.xls'
 
J

John Bixtis

If i understand your question correctly, all you need to do is to open this
other workbook, type in the cell "= if(b22=20," and then point to the cell
that you want to take the text if the value is true. You should get
something like

"'C:\Documents and Settings\me.only\Desktop\[Example.xls]Sheet1'!$A$1"

Then just type: ,"")

So your formula should look like:

= if(b22=20,"'C:\Documents and
Settings\me.only\Desktop\[Example.xls]Sheet1'!$A$1","")


A.
 
D

Dave F

=IF(B22=20,[link to prices.xls],"")

You just have to create the link when you're constructing the formula.
Without knowing the specifics of what you're trying to do it's impossible to
give you a more detailed answer than that.
 
Top