Results 1 to 2 of 2

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

Threaded View

  1. #1

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

    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.

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