I update attributes for account numbers that come from 4-5 different users. Updating the master list would be easy with VLOOKUP except that each user update would overwrite cells updated from the other users. So far I have been doing this by sorting the empty cells then doing the VLOOKUP. I am thinking there must be a formulaic solution but cannot think of one. Any suggestions?

Thanks in advance.