PatRichard
New Member
- Joined
- Dec 29, 2018
- Messages
- 29
- Office Version
- 365
- Platform
- Windows
I have a product number that I use multiple cells to grab various characters from. So, example is UI1950202TB, and then one cell grabs the 'U', next cell grabs the 'I', etc. I'm trying to then use VLOOKUPs to take the values of those cells and populate others. It seems that for cells where the computed value is a number, it doesn't work. But cells where the computed value is letters, works fine.
If I hard code the numbers in those cells instead of calculating by using MID(), the VLOOKUPs work fine. It's just when I use a formula to determine their value that the numeric ones fail.
Ideas on workarounds?
If I hard code the numbers in those cells instead of calculating by using MID(), the VLOOKUPs work fine. It's just when I use a formula to determine their value that the numeric ones fail.
Ideas on workarounds?