basically here it is have a work book to track items going into condo units.
I have broken down types given them ID's ie. "bath A, bath B and so on and
so on.
I have all of the unit styles broken down by ID as well i.e. "1a,1b,2a and
so on".
Each unit contains some combination of a kitchen 1-4 baths and 0-2 wet bars
I have a spread sheet that breaks all of these out and puts the corresponding
letters into each actuall unit# but here's the kicker.

In worksheet 2 are all of the bathroom descriptions with the ID collumn,
each bathroom contains a configuration of 1-5 cabinets all with different
names. I need to substitute the ID value in my master with the values of all
cabinets in that bath type so that I can count how many of each size and name
I have I have been messing with this for far to long now and I really have no
clue what I'm doing so its not going to well any help would be great

check this out:

http://spexx.biz

"HELP on data reference formulas" wrote:

basically here it is have a work book to track items going into condo units.
I have broken down types given them ID's ie. "bath A, bath B and so on and
so on.
I have all of the unit styles broken down by ID as well i.e. "1a,1b,2a and
so on".
Each unit contains some combination of a kitchen 1-4 baths and 0-2 wet bars
I have a spread sheet that breaks all of these out and puts the corresponding
letters into each actuall unit# but here's the kicker.

In worksheet 2 are all of the bathroom descriptions with the ID collumn,
each bathroom contains a configuration of 1-5 cabinets all with different
names. I need to substitute the ID value in my master with the values of all
cabinets in that bath type so that I can count how many of each size and name
I have I have been messing with this for far to long now and I really have no
clue what I'm doing so its not going to well any help would be great