How to check if a column has a value on a certain row with matching cell?
I have two sheets, Allocations & Installations.
Once an Allocation is approved, the row gets copied to Installation. When the Installation is completed it is marked as such on the same sheet. I would like to automatically have it marked on Allocation as well.
They share a [Shop ID] cell. So i need to check from Allocation with a reference to Installation if it has the Shop ID and on that same row if the cell in [Completed] has a value. There are multiple 'completed' values in [Completed].
If so, I want [Completed] on Allocations to be filled in or checked for that Shop ID.
I just can't get this done with any combination of VLOOKUP, INDEX, MATCH or IF/AND functions in any way and have exhausted Google & this community by this point.
Can anyone point me in the right direction?
Help Article Resources
Check out the Formula Handbook template!