vlookup - again

gumby

New Member
Joined
Apr 1, 2002
Messages
13
I have this =VLOOKUP(B17,$A$40:$B$49,2,FALSE) in my sheet. cell b17 has "=a43".(I'm assuming this is the problem) It gives me the error #N/A. how can I format the b17 cell reference in vlookup so it will see it as a cell reference and not text.
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
On 2002-04-07 12:44, gumby wrote:
I have this =VLOOKUP(B17,$A$40:$B$49,2,FALSE) in my sheet. cell b17 has "=a43".(I'm assuming this is the problem) It gives me the error #N/A. how can I format the b17 cell reference in vlookup so it will see it as a cell reference and not text.

I presume that B17 houses the formula

=A43

If so, What houses A43?

Moreover, is this A43 in the same sheet as your lookup table $A$40:$B$49?
 
Upvote 0
You probably want to put the value to be looked up in B17.

Go to B17 and enter an amount to be looked up. If you enter something that is recorded in the same way as the information in A43:A49, the formula will give the information in the adjacent column (B).

If you try to lookup something that is not in your lookup range, you will get the message #N/A.
 
Upvote 0
Maybe you want to try this

=OFFSET(INDIRECT(B17),,1)

will return the adjacent cell to the
right of cell address A43

Regards,

Peo Sjoblom
 
Upvote 0
cell a43 contains text "chaintech excel"
I want vlookup to look in cell b17 which has "=a43" then return the data in cell b43
 
Upvote 0
On 2002-04-07 14:13, gumby wrote:
cell a43 contains text "chaintech excel"
I want vlookup to look in cell b17 which has "=a43" then return the data in cell b43

You don't mean that B17 has "=a43" literally including the double quotes, do you?

If so, why is that?
 
Upvote 0
If you have "=a43" in b17 your value will be a43.....If you want the text from a43 to be the value in b17 use =a43 without the "" around your formula.....



Denny
This message was edited by kinkyparamour on 2002-04-07 14:32
 
Upvote 0
I already gave you the solution, you cannot use vlookup..

=OFFSET(INDIRECT(B17),,1)

will return what's in B43 if B17 contains a43

why don't you try it?

Regards,

Peo Sjoblom
 
Upvote 0
On 2002-04-07 14:52, gumby wrote:
no, the entry in b17 does not have quotes
b17 contains =a43

Now, please answer: In which sheet (sheetname) is your

=VLOOKUP(B17,$A$40:$B$49,2,FALSE)

B17

A43

and

B43?
 
Upvote 0

Forum statistics

Threads
1,213,490
Messages
6,113,956
Members
448,535
Latest member
alrossman

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top