Forum Discussion

UserBlue1973's avatar
UserBlue1973
Copper Contributor
May 19, 2020

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 UseWith...
excel
  • UserBlue1973's avatar
    UserBlue1973
    Copper Contributor
    May 20, 2020

    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?

    • bhushan_z's avatar
      bhushan_z
      Iron Contributor
      May 20, 2020

      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&"]"))))

Resources