Cell 1 to equal Cell 2, if 2 blank, then 3, if 3 blank, then 4
I have 4 cells, what I need is:
Cell 1 to equal Cell 2
If Cell 2 is blank, then read Cell 3,
If Cell 3 is blank, then read Cell 4.
I have searched quite a few discussions to try and replicate but cannot seem to get it to work.
Cell 1 - Approval Status
Cell 2 - Approver 1
Cell 3 - Approver 2
Cell 4 - Approver 3
Any help to resolve would be greatly appreciated!
Help Article Resources
Check out the Formula Handbook template!