excel - Finding if a value is located in a range of cells in a corresponding column, to a row with the same value as a given cell in a given row -
given column contains directory paths, , column b contains actions on these paths; i'd resultant cell contain specific string if specific string located in column b (per column a). granted can sort column, believe can use offset , know how locate ending index of cells can search range returned offset . for example: path operation /share/admins accessed /share/admins removed /share/admins added /share/admins changed /share/network accessed /shared/projects accessed in case, want search path unique value (in case /share/admins , /share/network , , /shared/projects ), , given range in path , i'd search corresponding operation , , if operation matches removed , added , changed exists, i'd cell value write ; , if values aren't found, "read". in case, expect column (with header result ) read: path operation result /share/admins accessed write /share/admins remov...