elsteshepard
05-01-2009, 07:53 AM
this should be simple, but it's not...
This is the usual formula for a vlookup;
vlookup(A1,'range',3,FALSE)
My problem is A1 is a formula
It doesn't like it
I want it to look up the value of A1, not A1 the formula
is that possible?
This is the usual formula for a vlookup;
vlookup(A1,'range',3,FALSE)
My problem is A1 is a formula
It doesn't like it
I want it to look up the value of A1, not A1 the formula
is that possible?