Get vlookup to recognize 102A as a lookup value

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.

By: Laura

5 thoughts on “Get vlookup to recognize 102A as a lookup value

  1. ig

    I really like your blog.. very nice colors & theme.

    Did you design this website yourself or did you hire someone to do it for you?

    Plz answer back as I’m looking to construct my
    own blog and would like to find out where u got this from.
    thank you


    Heya superb blog! Does running a blog like this require a lot of work?
    I’ve absolutely no knowledge of programming however I was hoping
    to start my own blog in the near future. Anyway, if you have any ideas or techniques for new blog owners please share.
    I understand this is off subject but I simply needed to ask.
    Many thanks!

  3. Samual Swearingin

    We stumbled over here different website and thought I may as well check things out. I like what I see so i am just following you. Look forward to looking into your web page for a second time.

Comments are closed.