On Dec 23, 12:03*pm, daydd wrote:
When I update my master worksheet, I want to save time by updating several
tabs at the same time.

I am using the following formula/function:
=VLOOKUP("BOS",Master!A$3:B$26,2,FALSE)

I have several dealers within the BOS region. I want in column A (BOS
"region"), column B (dealer code), column c (dealer name), etc. The above
function is pulling over the Region, but not separating the dealer info
(dealer code, name, etc), how do I keep it from duplicating, but pull over
ALL dealer info under the BOS region? *Or is there a better formula that
might work?

Thanks in advance for your help,

VLOOKUP returns only one answer. You are trying to have VLOOKUP search
on the region, which has several items, so it can't work. You need to
search on a choice that is unique. Are the dealer codes unique? You
could search on those instead, but then they would have to be entered
in the secondary sheets. Otherwise you need a different method.
Advanced Filter might be a good choice.