Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Look in a table

  1. #1
    Guest

    Default

    I want to look for a data in a table.

    Find the data which is in row 3 if the data of row 1 and 2 are matching my values.

    I have
    A ; H ; K
    B ; J ; K
    B ; K ; L

    If row1=B and row2=J then I want the data in row3.

    Thanks for your help.

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,599
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-03-06 13:57, Anonymous wrote:
    I want to look for a data in a table.

    Find the data which is in row 3 if the data of row 1 and 2 are matching my values.

    I have
    A ; H ; K
    B ; J ; K
    B ; K ; L

    If row1=B and row2=J then I want the data in row3.

    Thanks for your help.
    Lets say that A2:C4 houses the sample you provided.

    In E1 enter: B [ a condition ]

    In E2 enter: J [ likewise a condition ]

    In E3 enter:

    =INDEX(C2:C4,SUMPRODUCT(MATCH(E1&"@"&E2,A2:A4&"@"&B2:B4,0)))

    Caveat. The formula expects that there are identical rows of values (duplicates) in the range of interest.

  3. #3
    Guest

    Default

    It works great !
    Thanks a lot.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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