multiple sheets, need help please

K

Kile

I have a multiple sheet workbook. I want one cell on my second sheet to show
either one cell or the other, depending on what is selected, from my first
sheet. How can I do this?

Thank you.
 
B

bpeltzer

Where you want that result to appear, create a formula using the IF function.
The equation will be something like =if(a1=1,Sheet1!b4,Sheet1!c5).
The first argument (up to the first comma) is the condition, a logical test.
If it's true, then the result of the second argument will be the function's
result; otherwise the third argument will be the result. The easiest way to
enter the cell references while entering the formula is to click on the
cells; then Excel will deal with the syntax for referencing other workbooks
and/or worksheets.
--Bruce
 
Top