Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jul 2007
    United States
    Thanked 0 Times in 0 Posts

    VLOOKUP Error (MS Excel 2003)

    I am trying to return values in B1:B6 when B8:B28 matches A1:A6. Whether using TRUE or FALSE range_lookup, not sure why it isn't returning the value I want. It doesn't like my col_index_num reference. Thanks for the help.

    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: VLOOKUP Error (MS Excel 2003)

    The formula in C8 should be


    This formula can be filled down to C28.
    The first argument is the value to look for, i.e. a single value.
    The second argument must be a range that includes both the column in which you want to search and the column from which you want to return a value.

    If you want to use a single formula in C8:C28, it must be an array formula, confirmed with Ctrl+Shift+Enter instead of just Enter. The array formula is


Posting Permissions

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