I would like to use the VLOOK formula to show the value of a cell that is
using a formula. For example. I have entered data on Sheet 1 in cell b2. On
Sheet 2 cell b2 is a formula =IF(ISBLANK(Sheet1!b2)," ",Sheet1!b2). Since
there is data on Sheet 1, data appears on Sheet 2. On Sheet 3 I want to use
a VLOOK command that will find the value on Sheet 2 in the A column and show
the value of Sheet 2 b2.(I am using ranges, I have just simplified this for
explanation purposes) I would like to avoid referencing Sheet 1 from Sheet 3
if possible. Can this be done?
David