match cells

[chief]

What would be the formula to put in a sheet1 cell so that it would tak
a sheet2 cell value (text) and put it in that sheet1 cell. The reaso
being is i have sheet2 set up as products which will chang
periodically, and would like to have it so that the user can go in an
edit the sheet2 product and it will automatically show up as the ne
product in the sheet1 cell.

Thank

 

[Frank Kabel]

Hi
try
='sheet2'!A1

 

[chief]

Thanks Frank

I think i tried every combo like that, except for that one.