Jun 28 2019 10:56 AM - edited Jun 28 2019 11:51 AM
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 just 0, which, as a SKU, I can't allow. How do I keep "0000" as text but still use vlookup? Thank you!
Here's an example data set:
Jun 28 2019 11:09 AM
Hi,
Could you provide us with a sample of the data you working on (including the VLOOKUP formula) as an attached spreadsheet?
Jun 28 2019 11:32 AM
Jun 28 2019 11:53 AM
I added an example above @Haytham Amairah
Jun 28 2019 12:25 PM - edited Jun 28 2019 12:27 PM
In this case, you have two options:
=INDEX('Example Base Data'!$B$2:$B$5,INDEX(MATCH(--A2,--'Example Base Data'!$A$2:$A$5,0),))
You will notice the double negative sign (--) used in MATCH function, it's used to convert the numbers that are stored as texts to numeric numbers.
Hope that helps
Jun 28 2019 12:43 PM
@Haytham Amairah Hi, it seems to work in that sheet. I can't get it working in my data but I'll keep messing around with it and let you know what I find. I appreciate the help!