Urgent help needed On multiple criteria matching:
From the following tables:
Table:1
A B C D
Fruit No Rejected Result
1 Apple 500 Yes Alpha
2 Orange 1000 No Beta
3 Banana 200 Yes Gamma
4 Pomogranate 600 No nutron
Table:2
E F G
Fruit No Rejected
1 Litchi 20000 Yes
2 Kiwi 12 Yes
3 PApaya 32 No
4 Apple 500 Yes
The formula should check as below:
Look up value of A1 of Table1 from that of table 2 (E1:E4), Once it is found i.e.,table 2- E4. Then it should check corresponding other columns from the same row from both tables for further correctness of data like;
- whether table-1 B1is also equal to table-2 F4 & also
- Table-1 C1is also equal to table -2 G4
then give result pertaining to corresponding cell from column D i.e.,
Kindly help me, I have tried IF, lookup but could not get proper results.
Bookmarks