Nested ISBLANK Formula
I want to be able to look up changes to e.g. employee name, Job Title etc in a sheet and update the any changes on a staff sheet. However, if for example, their job title hasn't changed I need the formula to refer to 'old job title' column. I have a unique identifier of the Employee ID so, wondered if an INDEX MATCH would work with a nested ISBLANK to get it to refer to the 'old' column. Would this work and if so, could someone help with building the formula out? Or any alternative suggestions would be gratefully received.
Help Article Resources
Check out the Formula Handbook template!