Hopefully my example will help explain my issue. I had terrific help in merging several workbooks into one worksheet. It worked perfect and now I need to tweak the list for two separate functions. The list in A:D list each Fire Zone (Zone) and then identifies which Engines respond to that zone. Perfect! But, now my boss asked me if I can list each Engine company and show what Fire Zones (Zones) they respond to (F:AF). Each Engine company responds to a variable number of zones with no one engine resonding to a max of 25 zones, but more likely around 10 zones)
I tried some index and match formulas along with a few if statements, but fell short. Not sure how to proceed.
Thanks for the help.