Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Arlington, Texas, USA
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    VLOOLUP Returns #N/A (Excel 2002)

    I have two spreadsheets - the data comes from different sources. In one sheet I have a column that lists a member number, center number, center name, etc. In the second sheet I import a text file that includes member number, center name, etc. I use VLOOKUP to add the center number included in sheet #1 to the information in sheet #2. The formula returns a #N/A - I understand that that means that it did not find a match. I made sure that the cells are formatted the same - I have tried text, general, and number. If I type the member number over the number in sheet 2 Excel now finds the corresponding value in sheet #1 - but if I leave the cell with the imported information it returns the error. The numbers are the same. Any ideas?
    Thanks - shihalud.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: VLOOLUP Returns #N/A (Excel 2002)

    If one is a number and the other is text that looks like a number, they will not find a match.

    Either the lookup table data must be converted or the source data, depending on whichever is easier.

    You can convert with the TEXT function (convert numbers to text) or VAL( to convert text to numbers). If your table is text that looks like number, using copy and paste to add zero to them, will convert them to numbers.

    Steve

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Arlington, Texas, USA
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VLOOLUP Returns #N/A (Excel 2002)

    Thanks that worked - actually I imported into Access converted the field using an update query and the VAL function, then used the used the Analyze with Excel tool in Access - now it works. What a mess! Thanks again - shihalud.

Posting Permissions

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