Using Cell references in VLookUp

J

JonWilson631

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

=VLookUp(C3,TableOne,2)

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

Does anyone know why?

Thank
 
M

Max

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

trouble with (complicated) vlookup searching another workbook 2
Vlookup question 3
Using IF and VLOOKUP for range of cells 5
VLOOKUP duplicate values in table the table array? Help me solve 1
Using a vlookup to search multiple criteria for one result? 7
If function across sheets prints value of cell 4
Refer to a named range indirectly 1
Use vlookup within offset? 4

Top