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 |
