I need help from the experts here. Had been cracking my head on how to do a check on Cell G2 of this sheet "Checking". We will first need to match the A2 of the same sheet with Column B in the master list on "Inv Master List", then compare the results for the header group FL, DN, TF and WH.
We only need to return 2 results, OK and Unmatch and to fill a colour on the Unmatch cell. In order to match it, all data from the two groups must equal. If TF is 0, both TF needs to be 0 or blank. Need not necessary all fields have data.
Hoped someone can help. Have a nice day.
Bookmarks