vlookup with multiple instances

zfa32937

New Member
Joined
Jun 23, 2015
Messages
6
I have a list of over 1000 drawings in one column and the building the drawings are associated with in another column. I have another list of drawings I am trying to match the right buildings to using a vlookup but the problem I am having some some drawings have multiple buildings associated to them.

If a drawing has more than one building associated to it I need to know how many unique buildings that drawing is associated to and what those buildings are. Is there any way I can do that in excel?
 

AhoyNC

Well-known Member
Joined
Oct 10, 2011
Messages
4,375
Office Version
365
Platform
Windows
Probably the easy way would be to use Filter or Advance Filter.
It would help if you could post a small sample of your data and ver. of Excel you are using, but maybe the example below will help if you need a formula.
This is an array formula and must be entered with CTRL-SHIFT-ENTER.
Drag formula across and down as needed.
Excel Workbook
ABCDEFG
1DrawingBuildingDrawingBuildings
21B11B1B3
32B22B2B5
41B34B4
54B4
62B5
Sheet
 

Forum statistics

Threads
1,085,838
Messages
5,386,248
Members
401,988
Latest member
Sherzodom

Some videos you may like

This Week's Hot Topics

Top