Results 1 to 2 of 2

Thread: [RESOLVED] VLOOKUP range in second sheet returns #N/A

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2006
    Location
    London, UK
    Posts
    816

    Resolved [RESOLVED] VLOOKUP range in second sheet returns #N/A

    There is something strange about this lookup.
    The lookup table was copied in from another workbook using a macro.

    There is some formatting problem with cell A2. If you type 3001 in again over the old number it works.

    Does anyone know what the problem might be?
    Attached Files Attached Files
    Last edited by sgrya1; Jan 18th, 2010 at 05:56 PM.

  2. #2

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2006
    Location
    London, UK
    Posts
    816

    Re: VLOOKUP range in second sheet returns #N/A

    I worked it out.

    If I right click on cell A2 and press Format Cells it wrongly tells me that the format is a number. It's actually stored as text. Cell A3 is stored as a number.

    However I do want the numbers to be stored as text so I've had to rework some code to make sure that the lookup numbers are also being written to the sheet as text.

Posting Permissions

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



Click Here to Expand Forum to Full Width