Using Cell references in VLookUp
 

I am attempting to input a VLookUp formula, a simplified version is as
follows:

=VLookUp(C3,TableOne,2)

Easy enough. And as long as the contents of cell C3 is a number, the
Vlookup returns a value. But my cell C3 contains a formula (involving
another VLookUp to another Table -- not the same table) and I am
getting "A Value is Not Available to the Formula of Function".

Does anyone know why?

Thanks


--
JonWilson631
------------------------------------------------------------------------
JonWilson631's Profile: http://www.excelforum.com/member.php...o&userid=16005
View this thread: http://www.excelforum.com/showthread...hreadid=275092

One guess ..

If it's numeric lookup values, perhaps try instead:

=VLookUp(C3+0,TableOne,2)
or
=VLookUp(C3*1,TableOne,2)

The "+0" and "*1" will coax Excel to recognize any text
numbers returned by the vlookup in C3 into "real" numbers
without changing the value returned

--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <atyahoo<dotcom
----
"JonWilson631" wrote in message
...

I am attempting to input a VLookUp formula, a simplified version is as
follows:

=VLookUp(C3,TableOne,2)

Easy enough. And as long as the contents of cell C3 is a number, the
Vlookup returns a value. But my cell C3 contains a formula (involving
another VLookUp to another Table -- not the same table) and I am
getting "A Value is Not Available to the Formula of Function".

Does anyone know why?

Thanks


--
JonWilson631
------------------------------------------------------------------------
JonWilson631's Profile:
http://www.excelforum.com/member.php...o&userid=16005
View this thread: http://www.excelforum.com/showthread...hreadid=275092