Dear All,
In my "x" sheet the data are like this:
In My "Y" sheet data are like this:
In Y sheet IRemarks column I need a formula that will check both the Employee name & client name with X sheet, if both are matching with x sheet, then result will come "SAME AS X", otherwise "CHECK", pls help providing a formula
In my "x" sheet the data are like this:
X SHEET | |
EMPLOYEE NAME | CLIENT NAME |
BIVISON | GARDEN UMBRELLA |
ADI | UMBRELLA |
ZIDAN | DINING TABLE |
In My "Y" sheet data are like this:
Y SHEET | ||
EMPLOYEE NAME | CLIENT NAME | REMARKS |
BIVISON | GARDEN UMBRELLA | SAME AS X |
ADI | UMBRELLA | SAME AS X |
ZISHAN | DINING TABLE | CHECK |