Forum Discussion

Brandon_1's avatar
Brandon_1
Copper Contributor
Jun 28, 2019

Using VLOOKUP for SKUs stored as text

Hi there,   I'm using vlookup and it's returning #n/a. I used =type() and found it's type 2 which is text, which is why it isn't working. However, when I convert text to number I go from "0000" to ...
excel
Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Jun 28, 2019

Brandon_1

 

Hi,

 

Could you provide us with a sample of the data you working on (including the VLOOKUP formula) as an attached spreadsheet?

Resources