Results 1 to 4 of 4
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts

    Vlookup where numbers on one sheet are text

    I have a spreasheet was existing account numbers on sheet1 and imported data on sheet "imported data"

    I want to use a Vlookup on sheet1 to lookup the description of the account numbers on sheet "imported data" , but the formula returns #N/A

    Your assistance in resolving this using a formula will be most appreciated
    Attached Files Attached Files

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Your A column in sheet2 is text and you're looking for numbers. Change the text "numbers" to real numbers or look up the text equivalent.

    On Sheet1, something like:

    =VLOOKUP(IF(ISNUMBER(C1),TEXT(C1,"####"),C1),'Impo rted Data'!A1:C25,3,FALSE)


    Kevin
    Last edited by kweaver; 2013-04-02 at 09:37.

  3. #3
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts
    Hi Kevin

    Thanks for the help, much appreciated. I have used your formula, which works perfectly

    I have a similar problem using sumif which I will post in the next 5 mins. I still need to familiarise myself with this formula

    Regards

    Howard

  4. #4
    Star Lounger
    Join Date
    Oct 2012
    Posts
    55
    Thanks
    1
    Thanked 10 Times in 10 Posts
    Hi HowardC

    Perhaps another way and perhaps shorter, is to convert the lookup number to text, I have also wrapped in a IFERROR as you uploaded a .xlxs file.

    =IFERROR(VLOOKUP(C1&"",'Imported Data'!A:C,3,FALSE),"")

    Kevin

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •