Match text if in column

[dewotorf]

Book2.xlsx
	I
9
Sheet1

[/RANGE In column C, I want to match all IDs that are in column A and B. Basically, I want a formula that will look in the range B2:B13 and if there is an ID that matches any in Column A, then column C should display this ID to match the one in the corresponding cell in column A. For example; cell C20 should show de0001102341 because it exists in A20 and B8. Please help.

 

[Fluff]

In future when using XL2BB you need to select the range of cells your interested in, not a single blank cell.

How about

+Fluff 1.xlsm
	A	B	C
1	GridRef
2	NY777439	NY777439	NY777439
3	SK055741	SK059739
4	SK073782	SD953077
5	SE091296	SK056479
6	SK084589	SS924388
7	SK059739	NY414249	SK059739
8	SK155760	SE065262
9	SD953077	SD814261	SD953077
10	SE123307	SK225609
11	SK056479	SE130302	SK056479
12	SS924388	SE032427	SS924388
13	NY414249	SD872217	NY414249
14	SO630791	SE116095
15	NY905381
16	SE065262		SE065262
17	NY844556
18	SD814261		SD814261
19	SD961055
20	SK225609		SK225609
21	SE130302		SE130302
22	NZ111509
23	SE032427		SE032427
24	SE098180
25	SD872217		SD872217
26	SE116095		SE116095
27	NZ018208
28	SX709732
29	NZ104510
30	SE098920
Master

Cell Formulas
Range	Formula
C2:C30	C2	=IF(COUNTIFS($B$2:$B$14,A2),A2,"")