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