Question
-
Topic
-
Excel Formula help
LockedI 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 ValueFromOrderDataDOrderData!
A B C D
test1 test5 test7 email16.com
test2 test21 test98 email4.com
test1 test2 test3 email1.comIn 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)