vlookup with text data

jcmeyer

New Member
Joined
Mar 26, 2002
Messages
6
I am having a problem using text data with the vlookup function. The lookup value is in text format and the first column of the data range is in text format. If I copy and paste the lookup value into the lookup value cell location, I get #N/A as a result of my vlookup function, even though the lookup value is in the first column of my data range.

If I type the lookup value into the the lookup value cell location, the function works fine. This isn't a solution that I can use, because I have a list of items to lookup and it would take too long to copy and paste the values and retype these values in the same cell.

Has anyone encountered this issue before?
 
Hi John:
Your formula is OK! The problem is with the way the Lookup value is entered. If you enter the lookup value literally in the formula, text values must be enclosed in quotes. The prefered way is to use Lookup value in the formula by cell reference.
 
Upvote 0

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Forum statistics

Threads
1,213,527
Messages
6,114,142
Members
448,551
Latest member
Sienna de Souza

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