IF Function to return a reference instead of a value

[gin]

Is there any way to make an IF Function return the value
of another cell, instead of the value stated w/n the
function. I am trying to create a summary worksheet.

I have: =IF('Sheet 1'!B2>0,"='Sheet 1'!A2","=A3")
if it's true it returns: ='Sheet 1'!A2 (instead of
returning the contents of Sheet 1 cell A2)
if it's false it returns: =A3 (instead of returning the
contents of cell A3)

If anyone has any other suggestions as to how to make this
come about without IF Functions I would be willing to try
it.

For Example:

Sheet 1
A B C D
1 Item Qty Price Extension
2 3'Beam 0 1.00 0.00
3 4'Beam 3 2.00 6.00
4 5'Beam 0 3.00 0.00
5 etc...etc...etc...

Sheet 2
A B C D
1 Item Qty Price Extension
2 3'Panel 0 0.25 0.00
3 4'Panel 5 0.50 2.50
4 5'Panel 0 0.75 0.00
5 etc...etc...etc...

Sheet 3 (should look like this)
A B C D
1 Item Qty Price Extension
2 4'Beam 3 2.00 6.00
3 4'Panel 5 0.50 2.50
4 etc...etc...etc...

Thank you, in advance, for your consideration and time.
-gin.

 

[Dan E]

Gin,

You don't need the quotes or the ='s

=IF(Sheet1!B2>0,Sheet1!A2,A3)

Dan E