Dear expert
I have set of data which is combined with multiple partner name
i want find which are partner name wrongly updated in H:H by look up of pudo code in E2, from pudo list(sheet2)
I want check for the pudo exact partner name is updated in H:H if not updated as per list. towards O:O column i want remarks as Wrong Partner Name
i want check in M:M column formula IF(OR(J2>=DATEVALUE("06/30/2015"),J2=0),I2,"999") which should have date of 06/30/2015 which are not exact date towards N:N column i want remarks as "Wrong Date Updated"
find the attachment you may understand what actually i looking for
Bookmarks