Forum Discussion
Check if parent row has corresponding values
I have a table in an Excel 2016 spreadsheet that has hierarchical rows:
(Here's an Excel-friendly version that can be copied/pasted into a spreadsheet.)
| ID | PARENT | UseWith1 | UseWith2 | UseWith3 | UseWith-CheckParent |
| 10 | WORKORDER | SR | |||
| 20 | 10 | SR | |||
| 30 | 10 | WORKORDER | JOBPLAN | ||
| 40 | 10 | WORKORDER | |||
| 50 | 40 | WORKORDER | JOBPLAN | TOOLITEM |
Question:
In column F, I want to flag child rows where the values in C, D, or E are missing from the parent row.
Example:
Is there a way to do this in Excel 2016?
5 Replies
UserBlue1973 refer attached file
bhushan_z Thanks, however, I can't download the .xlsm file due to security reasons.
Is there a reason why the file needs to be a .xlsm?UserBlue1973 : even i m not sure it was saved as .xlsm, hahaha
here is new file in .xlsx
Also refer below formula just for your reference.
=IF(B2="","",IF(AND(D2="",E2=""),"",IF(D2="","ERROR["&E2&" is missing from parent #"&B2&"]",IF(E2="","ERROR["&D2&" is missing from parent #"&B2&"]","ERROR["&D2&" and "&E2&" is missing from parent #"&B2&"]"))))
