Thanks for the reply. I entered the formula below and it did not work. The
cell value still shows #REF. I spent a lot of time yesterday trying to find
the answer using help, but to no avail. Could something else be interfereing
with the function of the formula? Perhaps I need to change the format of the
cells?

One item I noticed when I use the Insert Function command (fx) the line for
the Table Array shows #NUM in red at the end of the line. Normally I would
expect to see values appear in parenthesis at the end of the line. This
might be the problem, but I do not know how to fix this. Any ideas?
David

"JLatham" wrote:

Absolutely, just look at Help on VLOOKUP() for details. But there is no
reason you cannot do what you want.

The formula on Sheet3 would look something like this:
=VLOOKUP(A2,Sheet2!A2:B5,2,0)
this assumes that the value you want to match up with is on Sheet3 in cell
A2 ( I put that formula on my Sheet3 in cell A3 just for testing).

"David" wrote:

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