INDEX/MATCH for Mirroring Status Column in Another Sheet
This may not be right formula, but if a user shared a sheet with me which contains a project codes column and a status column (complete/incomplete), and I use the same project codes, can I do a formula which pulls in their status into my sheet? Something like -
If (External Referenced Sheet / Column A) matches project code in (My Sheet / Column A),
then add the value in (External Referenced Sheet / Column B) from (External Reference Sheet / Column B) intro (My Sheet / Column B).
Help Article Resources
Check out the Formula Handbook template!