Return a value within a range

Joecam

Member
Joined
May 22, 2014
Messages
41
Reaction score
0
Points
6
Excel Version(s)
365
I have a spreadsheet with a data dump that lists contact IDs and tags for each contact ID. The tags represent the caller, the type of call & the state of the call.

Each contact ID should have 3 tags and currently each tag appears on a separate row while duplicating the contact ID.

I've extracted a list of unique contact IDs to a separate list. Now what I'm trying to do is get each type of tag (Caller, type & state) into a separate column by matching to the contact ID. I've created a table that identifies the tags that belong into each category, but how can I populate the column?
 
Sheet 2
C2=INDEX(Sheet1!$D:$D,SMALL(IF(Sheet1!$B$1:$B$999=$A2,ROW(Sheet1!$A$1:$A$999),"/"),COLUMN(A1))) "control+shift+enter" then copy to right and down

if you see "#num" , that means ID in column A is not shown in column B of Sheet 1 for 3 times.
 
Back
Top