Someone from your group had assisted me in creating a VLookup for my document. I am noticing that some of the rules are not working properly. When entering the store number it should auto populate the address, city, state, zip, store MGR, Area MGR, Market MGR and starting pay. It’s not doing that for all of the cells Also, nothing happens when I enter in store # 090004 & 090006.
Also, could you lock down those fields, so the formula does not get deleted in error?
Solved by G. J. in 22 mins