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

#### brymer

##### New Member
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?

### Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
What's the formula in the other cell?

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.

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

lenze

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?

=TRIM(A68)="Arizona"

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

Replies
3
Views
138
Replies
5
Views
271
Replies
8
Views
89
Replies
6
Views
163
Replies
3
Views
117

1,203,101
Messages
6,053,535
Members
444,670
Latest member
laurenmjones1111

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back