Matching Data

[Excel_77]

In the "Master" tab I have a series of IDs in column A, I want to check the IDs against column A of the "source" tab and return a value to column B of the "Master" tab. If the ID is in one of the present columns within the "source" tab (b-d), I want the column heading (b2) of the master tab returned in each of the applicable cells within column B of the "Master" tab, is this possible and if so how?

Book2
	A	B
1	ID	Test (41)
2	12345677
3	12345678
4	12345679
5	12345680
6	12345681
7	12345682
8	12345683
9	12345684
10	12345685
11	12345686
12	12345687
Master

Book2
	A	B	C	D
1	ID	Present 1	Present 2	Present 3
2	12345677
3	12345678		12345678
4	12345679	12345679
5	12345680	12345680
6	12345681			12345681
7	12345682
8	12345683
9	12345684
10	12345685
11	12345686
12	12345687			12345687
Source

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B
1	ID	Test (41)
2	12345677
3	12345678	Present 2
4	12345679	Present 1
5	12345680	Present 1
6	12345681	Present 3
7	12345682
8	12345683
9	12345684
10	12345685
11	12345686
12	12345687	Present 3
Master

Cell Formulas
Range	Formula
B2:B12	B2	=IFERROR(INDEX(Source!$B$1:$D$1,AGGREGATE(15,6,(COLUMN(Source!$B$1:$D$1)-COLUMN(Source!$B$1)+1)/(Source!$B$2:$D$12=A2),1)),"")

 

[Excel_77]

It works in my test scenario but not in my main file. I don't understand much of the code, is there an alternative solution?

 

[Fluff]

Could do you have a value in cols B, C or D that is different to the value in col A?

 

[Excel_77]

No, the value would be the same.

 

[Fluff]

In that case that's the simplest formula I can think of.
Are the columns the same in your actual file as the sample?