Cross referencing columns.

[SloopJohnB]

I would like to use the data in Tab Building column H to form a list in the Service Dropper Count tab Column C without having multiple entrys ie a summary list of the entrys. Also the do the same for the column lists on row 3 using the entrys from Building tabs column I.

Attached is a same spreadsheet to help with the question.

Thanks alot.

[ajryan88]

Hi,

I have used array formulae in your required cells to achieve the desired outcome.

Let me know if you have any questions.

Hope this helps

[SloopJohnB]

Thanks for your help.