Forum Discussion
Convert information in a cell into words
OK, So first off my apologies as I didn't realize I could actually download what you posted (Thought it was a screenshot, just joined the message board yesterday!), I am an idiot and probably shouldn't have been trying to help anyone yesterday. Very sorry.
Use this in G1, I tested it and it seems to work for me:
=VLOOKUP(IF(LEN(F1)>3,RIGHT(F1,3),(IF(LEN(F1)=2,"0"&F1,F1))),Color!A:B,2,FALSE)
Had to get a little more complicated with the formula as it looks like sometime you get the paint codes as 4 digit codes with an extra leading 0 and sometimes a 2 digit code with a 0 dropped off the front (In relation to the all the codes being 3 digits codes on your sheet "Color"). This is essentially the same formula I sent before but I added: If the paint code we want to look up is 4 digits, remove the first digit, If it's 2 digits add a "0" to the front, thereby always ending up with a 3 digit code to lookup on your other sheet.
Do you have a list of all of the codes and color names that you reference then?
Is the color code in cell by itself?
- I do have an Excel sheet with the codes and what color they reference, they are separated into different cells. The Excel sheet sent by email has the code in its own cell as well. The sheet references cars we receive in so there are columns for Vin, stock #, color code, etc.
