I have two spreadsheets. The master one has cost centers,
city and states. The second one has staff names and cost
centers. I need to pull in from the master the city and
state for each staff member (i'm talking about 4,000
people). Is there a way I can have a macro or something
go to the master worksheet and search for the cost center
and if found pull in the city and state for that person?
If I have a macro I don't mind doing it line by line (well
I do, but can't think of a faster method).

HELP PLEASE!