Data compare and result in another col

[JMC57]

I have DAta in Col A (Med ID ) and B has number of events assocaited with the unique ID. The Unique ID is also in Col C from another data source. I wnat to return the value from Col B in in Col C that mathces the MD ID if available. There are several more col in the sheet that have other dta that is not assocaited with this. HAving an Excel formula or VB code will help me do some analysis. Example

<TABLE style="WIDTH: 350pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=466 border=0><COLGROUP><COL style="WIDTH: 102pt" span=2 width=136><COL style="WIDTH: 73pt; mso-width-source: userset; mso-width-alt: 3547" span=2 width=97><TBODY><TR style="HEIGHT: 51pt" height=68><TD class=xl68 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 102pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 51pt; BACKGROUND-COLOR: transparent" width=136 height=68>Exported Med ID Data Source 1</TD><TD class=xl68 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 102pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=136>Exported Med ID Data Source 1 Number of Times Not Availle able </TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 73pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #9999ff" width=97>Med ID- </TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 73pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #9999ff" width=97>Matched Result From Col B to Med Id in C</TD></TR></TBODY></TABLE>

 

[JMC57]

BINGO! It Works! Thanks!