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