I've to compare two sheets with similar columns are :
Sheet1: Column A (O/N), Column B ( P/N), Column C (QTY), Column D (Date)
Sheet2: Column A (QTY), Column B (O/N ), Column C (P/N)
All Columns are in text format except Column D which is in Date mm/dd/yy).
Here I have to compare these two sheets and return value of Coulmn D of sheet1 on Column E of sheet2 with following conditions:
-If cln A of Sht1 equal to cln B of sht2 then go to copare cln B of sht1 with cln C of sht2;
-if both match, then compare cln C of sht1 with cln A of sht2;
-if these three column are matched, return value of cln D of sht1 on cln E of sht 2
I've tried to use MATCH and INDEX formula, but fail at all. Should I use array formula to solve such conditions?
Btw, anyone can help to post formula here?
Tks a lot.
Regards,
CL
Sheet1: Column A (O/N), Column B ( P/N), Column C (QTY), Column D (Date)
Sheet2: Column A (QTY), Column B (O/N ), Column C (P/N)
All Columns are in text format except Column D which is in Date mm/dd/yy).
Here I have to compare these two sheets and return value of Coulmn D of sheet1 on Column E of sheet2 with following conditions:
-If cln A of Sht1 equal to cln B of sht2 then go to copare cln B of sht1 with cln C of sht2;
-if both match, then compare cln C of sht1 with cln A of sht2;
-if these three column are matched, return value of cln D of sht1 on cln E of sht 2
I've tried to use MATCH and INDEX formula, but fail at all. Should I use array formula to solve such conditions?
Btw, anyone can help to post formula here?
Tks a lot.
Regards,
CL