Question

  • Creator
    Topic
  • #2169122

    Excel Formula help

    Locked

    by stealthwifi ·

    I have an Excel Workbook with two sheets.
    One called Form the other OrderingData.

    There are multiple row headings on Form.
    If an entry in Column A & B & C match the entry in A & B & C then D needs to be populated with the valued of D of the row that matched on OrderingData.

    Example:

    Form!
    A B C D
    test1 test2 test3 ValueFromOrderDataD

    OrderData!

    A B C D
    test1 test5 test7 email16.com
    test2 test21 test98 email4.com
    test1 test2 test3 email1.com

    In the above example A B & C match the third row in OrderData so email1.com should go in cell D on Form.

    The current formula I have doesn’t seem to work, it can only grab from a programed cell, I need it to grab from the cell to the right of the three results that match:

    =IF(OR(AND(B2=OrderingData!A:A,Form!C2=OrderingData!B:B,Form!D2=OrderingData!C:C),AND(Form!B2=OrderingData!A:A,Form!C2=OrderingData!B:B),AND(Form!B2=OrderingData!A:A)),OrderingData!D2,””)

    Any help is GREATLY appreciated!!!

    I tried the below and it comes close, but can only seem to serch and match one column, I need it to search and match all 3 for the results:

    =VLOOKUP(B2,OrderingData!A:D,4,FALSE)

All Answers

  • Author
    Replies
Viewing 2 reply threads