Update worksheet by comparing two cells

W

weeshie73

Hi All,

I'm struggling with a solution and hope you can help.

I have two worksheets, Local and Master, where both are set up a
follows:

A1: UniqueID A2: Acct# A3: LocationCode

I want to update my Master WS with the UniqueID from the Local WS
matching on Acct# and LocationCode. Can this be done by a formula o
is a macro necessary?

Thanks in advance!
Christin
 
Top