Returning data of multiple cells for lookup of mulltiple cells
 

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

Returning data of multiple cells for lookup of mulltiple cells
 

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