I can't figure out what is going on here. I have a bunch of phone numbers in a column and am trying to do a Vlookup. The formula keeps giving me an N/A. However if I manually type over inside the cell the numbers then the formula works. There are 240 lines so I can't do that for every line. Anyone have a workaround?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
excel is not recognizing values in cells
- Thread starter boston814
- Start date
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 72,244
- Office Version
- 365
- Platform
- Windows
Welcome to the Board!
In order for VLOOKUP formula to work, the values that you are matching on MUST be the same data type.
You can only match numeric values up to other numeric values.
And you can only match text values up to other text values.
Where people run into issues is when they try to compare numeric values up to numbers that have been entered by text (so they are actually text values, not numeric).
One quick way to fix it is to convert your text entered as numbers to numeric by selecting that column, going to "Text to Columns" on the Data menu, and clicking "Finish".
In order for VLOOKUP formula to work, the values that you are matching on MUST be the same data type.
You can only match numeric values up to other numeric values.
And you can only match text values up to other text values.
Where people run into issues is when they try to compare numeric values up to numbers that have been entered by text (so they are actually text values, not numeric).
One quick way to fix it is to convert your text entered as numbers to numeric by selecting that column, going to "Text to Columns" on the Data menu, and clicking "Finish".
Upvote
0
Solution
Similar threads
- Question
