I have a large excel sheet with many tabs and tons of information so I decided to use the Vlookup function to pull my imported data into the correct cells. The "look up" data uses a sequential number starting at 1.1 and ascending from there. My issues happens when I get to 1.10 or 1.20 and so on. The value that gets returned is the one associated with 1.1 and 1.2 respectively. I checked to make sure everything was stored as a number and I tried making sure there were 2 decimal places on the higher numbers but nothing seems to be working. I have created this sheet many times and this is the first time I am encountering this problem. Please, if you have any suggestions, let me know!
Bookmarks