vlookup issue

[Connor Doyle]

Folks,

Sorry if I'm phrasing this wrong, but I've got a vlookup issue that is
returning me N/A values. Here goes:

The lookup value is a cell which contains another looked up value. So,
for my formula =vlookup(C1,'sheet'!$a$1:$z$2000,2,TRUE), the C1 is
another vlookup that has returned a correct numerical result.

If I replace 'C1' with the number, it returns the correct result, but
for some reason it craps out on me if I have it reference C1 itself. I
also tried having another cell (C2) just be "=C1", and I have the same
problem.

Again, sorry if I'm butchering the lingo, but I'm a total noob. Hope
this is a solvable problem (from the looks of this message board,
there aren't many of the non-solvable type).

Cheers!

Connor

 

[Fred Smith]

What's the formula in C1? Sounds like it's returning text when it needs to
return a number.

Regards,
Fred

 

[Pete_UK]

Perhaps C1 is a text value that looks like a number. Try it like this:

=vlookup(C1*1,'sheet'!$a$1:$b$2000,2)

As you are only getting data from the second column of the table, it
does not need to be defined as a1:z2000. Also, TRUE can be omitted, as
it is assumed.

Hope this helps.

Pete