Results 1 to 5 of 5

Thread: HLOOKUP (NT)

  1. #1
    New Lounger
    Join Date
    Feb 2002
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    HLOOKUP (NT)

    I have a table of data that I am searching through, and I am using HLOOKUP to select the appropriate cell. The function will select the correct cell in half the table, but in the other half (columns 5-8, 11, & 12 of 16 total) it will select the adjacent cell.

    What is wrong, and what's the fix?

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: HLOOKUP (NT)

    Kind of tough to tell from what you have provided. Could you upload a sample workbook that shows the problem?
    Legare Coleman

  3. #3
    New Lounger
    Join Date
    Feb 2002
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: HLOOKUP (NT)

    Okay, here it is. On row 46 of tab "maybe" are the cells marked "HXC Input/1000", "% Derate", and "Unit CFM". Enter the proper value from row 1 (the cell in the first column of each "color" group), and the derate percent (0.98 to 0.6), and then an airflow value. The HLOOKUP command then pastes the proper values from both columns of the selected "color group" in the cells marked "Derated Input" and "Derated Output". At least it works for the 69, 90, 180, 390, 480, and 780 groups. In the 270, 351, and 540 groups, the HLOOKUP duplicates the "input" data in the "output" cell.

    How can this be fixed?
    Attached Files Attached Files

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: HLOOKUP (NT)

    The following is from the help file for the HLOOKUP function:

    "If range_lookup is TRUE, the values in the first row of table_array must be placed in ascending order: ...-2, -1, 0, 1, 2,... , A-Z, FALSE, TRUE;
    otherwise, HLOOKUP may not give the correct value. If range_lookup is FALSE, table_array does not need to be sorted."

    You omitted the Range_lookup parameter which use the default of True. Therefore, the values in the lookup row must be in ascending order.
    Legare Coleman

  5. #5
    New Lounger
    Join Date
    Feb 2002
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Thanks Legare Coleman

    After some rearranging and tweaking of the header values, and adding the logical tag, the spreadsheet is now working perfectly. Thank you so much for the help.

Posting Permissions

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