View Single Post
  #1   Report Post  
JonWilson631
 
Posts: n/a
Default 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