Question

Locked

Excel Formula help

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)

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Try

by unhappyuser In reply to Excel Formula help
Collapse -

not quite

by StealthWiFi In reply to Try

match returned the row number, I need the value of comulmn D with that row number

Collapse -

On each cell this works

by unhappyuser In reply to Excel Formula help

=IF(A2=OrderingData!A2,D2,D2=OrderingData!D2)

EMD

Collapse -

Solved

by StealthWiFi In reply to On each cell this works

Nope that didn't do it but I got it solved with a =lookup function

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums