PDA

View Full Version : vlookup probs



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?

Bob Phillips
05-01-2009, 08:01 AM
It will lookup the value of A1, as A1 will have the value returned from the formula.

elsteshepard
05-01-2009, 08:05 AM
I get a circular reference error when i try that

whereas if I type in the value of A1 and not the formula, it works

Bob Phillips
05-01-2009, 08:49 AM
Where is the lookup formual, and what is the formula in A1.

The circular reference is a bug in your spreadsheet, not LOOKUP.