Results 1 to 7 of 7
  1. #1
    Star Lounger
    Join Date
    Apr 2006
    Location
    Accra, Ghana
    Posts
    84
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formula problem (Excel 2003)

    Hello everybody

    My problem is as follows:

    I have a table from which I want to read information based on two variables, but I do not know what kind of formula to use to get the answers.

    I include a file to illustrate.

    I would appreciate any guidance.

    Thank you
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formula problem (Excel 2003)

    Enter the following formula in E10:

    =INDEX($D$3:$F$5,MATCH(C10,$C$3:$C$5,0),MATCH(D10, $D$2:$F$2,0))

    and fill down.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formula problem (Excel 2003)

    Alternatively, use

    =VLOOKUP(C10,$C$3:$F$5,1+MATCH(D10,$D$2:$F$2,0),FA LSE)

    in E10 and fill down.

  4. #4
    Star Lounger
    Join Date
    Apr 2006
    Location
    Accra, Ghana
    Posts
    84
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula problem (Excel 2003)

    Hans

    That must be fasted reply I have ever seen. Must be a record, 4 min taking into account display times.

    Thank you very much

    I appreciate it as always.

  5. #5
    Star Lounger
    Join Date
    Apr 2006
    Location
    Accra, Ghana
    Posts
    84
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula problem (Excel 2003)

    Hans

    I have something strange happening on my spreadsheet. For some reason when I copy my formula in the blue column down I get errors in some cells. I tried to check the formatting of the cells but do not see anything off hand.

    Do you have any idea what can be wrong?

    I attach a sheet demonstrating the problem

    Regards
    Attached Files Attached Files

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Formula problem (Excel 2003)

    In your table you have TCG 950(no space), but in some of your values in col F you have TCG 950(space). It is looking for an exact match. if there is a space after the item it does not match the lookup table which has no space.

    Steve

  7. #7
    Star Lounger
    Join Date
    Apr 2006
    Location
    Accra, Ghana
    Posts
    84
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula problem (Excel 2003)

    Hi Steve

    Thank you for that, I never checked that. I know the match have to be exact but I never thought the input clerk will add spaces after an entry.

Posting Permissions

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