Results 1 to 2 of 2

Thread: Vlookup

  1. #1
    Join Date
    Nov 2003

    Unanswered: Vlookup

    Can anyone help me with the attached VLOOKUP?

    In my "Total Calc" tab I create a vlookup to search for a value in the "raw data" tab, but it is giving me a N/A# response. I've sorted the data ascending and looked through an elementary Excel manual I have here, so maybe I am overlooking something?

    I appreciate your assistance.

    Attached Files Attached Files

  2. #2
    Join Date
    Oct 2003

    Re: Vlookup

    The VLOOKUP looks for the matching value in the first column of the range. You need to rearrange your data. Move the Column F to position A in the data then it will work.
    I have tried on your data and attaching the zip.
    (I have set the column width of the first column (affter moving) to zero so that it does not become irritating to see the additiononal column as the first one)
    Attached Files Attached Files

Posting Permissions

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