I have two sheets - sheet1 and sheet2,


ColumnA of sheet2 has a formula to calculate some values. I want the result to show in column A of sheet1 without placing a formula in ColumnA of sheet1..



for example


sheet2

columnA

cell - A3 contains -> =if(b2>0,"True","False")

i want the contents of sheet2, A3 to be displayed in Sheet1, A3 ( without putting a formula in sheet1A3). so no vlookup forumlas.

this is because in case i delete a row or add a row, the formulas will get messed. hence want to know how to achieve this.