Results 1 to 3 of 3

Thread: Vlookup

  1. #1
    Star Lounger
    Join Date
    May 2007
    Location
    Cape Town, Western Cape, South Africa
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unhappy Vlookup

    Hi

    Im busy with payment statement and I want to lookup invoice number in the first sheet and the second sheet. The invoice number is in Column C. I tried but it gives me NA, please help.
    Attached Files Attached Files

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    VLOOKUP requires the lookup value to appear in the first column of the lookup table. You need to alter the lookup range to start with column C, or use INDEX and MATCH instead.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Column headings/titles would be useful.
    There are two sets of VLOOKUP. One column of VLOOKUPs on each sheet.
    Are you trying to determine if the invoice numbers appear on each sheet?

Posting Permissions

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