Search Formula

[Sparda142]

What formula could i use to to find names in a of information? Would using a index and match make more sense than a Vlookup or something Else? I'm trying to say if the information in column A appears in Column C, Appear in Column B

	Column A	Column B	Column C
	Test agent 1 <tbody> </tbody>	(EXCEL Formula)	Test Agent 1
	Test agent 2 <tbody> </tbody>		schedule
	Test agent 3		3/26
	Test Agent 4		N/A
			Schedule ad
			Percent
			Test Agent 2
			Test agent 3
			Wednesday

<tbody>
</tbody>

 

[mrshl9898]

VLOOKUP will do the job. In B1

=IFERROR(VLOOKUP(A1,C:C,1,0),"")

 

[Sparda142]

Formula Worked! , Your Awesome , thanks for the help!