Vlookup function doesn't recognize values with a dash

16 views
Skip to first unread message

Chasing White Lines

unread,
Mar 27, 2024, 4:04:18 PM3/27/24
to Google Sheets Community
I'm trying to look for a value a number specifically to coincide with values in another table. The number in the cell is something like this 2112-2107. The adjacent cell has the information queried from another table shows 2112-2107. The vlookup refers to the queried cell and to return a value base on that number. Any cell where the part number does not contain dashes will return the value request. The cells with the part numbers that contain dashes will not. What am I missing here?! 

Chava

unread,
Mar 28, 2024, 3:05:05 PM3/28/24
to Google Sheets Community
Sounds like a data type issue, have you tried changing the data type to string? 
https://sheetsformarketers.com/how-to-convert-numbers-to-strings-in-google-sheets/
Reply all
Reply to author
Forward
0 new messages