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
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message