VLOOKUP: When the lookup value is a formula...

[brymer]

I am trying to use VLOOKUP in my worksheet, but the value I am looking up in an array is drawn from another cell in the same worksheet. It keeps giving me "#N/A" because I am not typing the text I am searching within the VLOOKUP formula within the " ". I need VLOOKUP to reference the cell that contains another formula.

For example:

=VLOOKUP(A68,A111:B142,2,FALSE)

Since I am not physically typing "Arizona" in the lookup value, it is returning the #N/A.

Can someone point me to a solution here?

 

[Norie]

What's the formula in the other cell?

 

[brymer]

It references a cell from a web query...so it is an "=CELL". But I can create a macro that copies it as a value only.

 

[lenze]

Untested, but maybe
=VLOOKUP(INDIRECT("A68"),A111:B142,2,FALSE)

lenze

 

[just_jon]

If cell A68 *appears* to say 'Arizona', check to see if that is the actual content of the cell. [ Guessing, not. ]

=A68="Arizona"

returns TRUE or FALSE?

How about -

=TRIM(A68)="Arizona"

 

[brymer]

The TRIM() worked perfectly and it helped to solve a lot of other issues I was having. THANK YOU VERY MUCH!