I’m using vlookup to populate a tally spreadsheet. It is working very well when the lookup value is a regular number – like 21073 (classified as a General Number). However, when the lookup value is 21073A (also classified as a General Number in Format cells) – it doesn’t recognize it and returns a value of 0 (I’m using it in combo with iferror). When I create a test table with this situation – it sometimes works and sometimes doesn’t. My source data for my spreadsheet is a CSV file – but the problem persists when I save it as an excel spreadsheet. I’ve tried a few of the solutions found on-line, but nothing seems to work. There is no option to change the source value to another number without the ‘A’. Any help would be most appreciated.