• MATCH, INDEX, OFFSET (A2K3)

    Author
    Topic
    #455801

    Good Morning Everyone,

    I need to Match the column in worksheet2 to a column in worksheet1 then match the row in the worksheet2 to a row in the worksheet1 and index the value in the corresponding column/row of the worksheet1.

    I’m certain I need to apply the MATCH and INDEX and probably the OFFSET but my logic doesn’t appear to be working so well. Here’s what I have so far.

    [indent]


    =IF(ISNUMBER(MATCH(B1,’Sheet2′!B1:C21,0)),INDEX(‘Sheet1′!B2:B22,MATCH(B1,’Sheet2’!A1:A22,0)),0)


    [/indent]

    Can someone please provide me with insight to this? I’m attaching a sample to better explain what I need to do.

    Viewing 0 reply threads
    Author
    Replies
    • #1136047

      Hi

      Does the attached does what you want?

      • #1136055

        Yes it does…thank you very much.

        • #1136064

          Thanks for the feedback

          another alternative if you want to use Index…Match as in your original post
          =IF(ISNA(INDEX(Sheet2!B2:B21,MATCH(Sheet1!A2,Sheet2!A2:A21,0))),”no patient”,(INDEX(Sheet2!B2:B21,MATCH(Sheet1!A2,Sheet2!A2:A21,0))))

    Viewing 0 reply threads
    Reply To: MATCH, INDEX, OFFSET (A2K3)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: