IS there VBA code to Data compare and result in another col

[JMC57]

=IF(COUNTIF($A$2:$A$7,C2)>0,B2,"")</PRE>
The problem is that the value that is being place in the cell is not the correct value. In this case NIMOOC30 is in A2 and the value associated with NIMOOC30 in B2 is 6. Hoever the value returned in D8 for NIMOOC30(C8) is 4. I need it to be 6
<TABLE style="WIDTH: 350pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=466 border=0><COLGROUP><COL style="WIDTH: 102pt" width=136><COL style="WIDTH: 102pt" width=136><COL style="WIDTH: 73pt; mso-width-source: userset; mso-width-alt: 3547" span=2 width=97><TBODY><TR style="HEIGHT: 51.75pt" height=69><TD class=xl68 style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; WIDTH: 102pt; BORDER-TOP-COLOR: #d4d0c8; HEIGHT: 51.75pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8" width=136 height=69>Exported Med ID Data Source 1</TD><TD class=xl70 id=td_post_3133491 style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; WIDTH: 102pt; BORDER-TOP-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8" 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-COLOR: 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><TR style="HEIGHT: 27.75pt" height=37><TD class=xl69 style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; WIDTH: 102pt; BORDER-TOP-COLOR: #d4d0c8; HEIGHT: 27.75pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8" width=136 height=37>NIMOOC30</TD><TD class=xl71 style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; WIDTH: 102pt; BORDER-TOP-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8" width=136>6</TD><TD class=xl67 style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; WIDTH: 73pt; BORDER-TOP-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8" width=97>REFR</TD><TD class=xl73 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: transparent">


</TD></TR><TR style="HEIGHT: 40.5pt" height=54><TD class=xl67 style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; WIDTH: 102pt; BORDER-TOP-COLOR: #d4d0c8; HEIGHT: 40.5pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8" width=136 height=54>DIPRVIAL</TD><TD class=xl71 style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; WIDTH: 102pt; BORDER-TOP-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8" width=136>5</TD><TD class=xl67 style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; WIDTH: 73pt; BORDER-TOP-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8" width=97>DIPRVIAL</TD><TD class=xl73 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; BORDER-TOP-COLOR: #3867a6; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: transparent">5.00


</TD></TR>


<TR style="HEIGHT: 40.5pt" height=54><TD class=xl69 style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; WIDTH: 102pt; BORDER-TOP-COLOR: #d4d0c8; HEIGHT: 40.5pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8" width=136 height=54>MS2</TD><TD class=xl71 style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; WIDTH: 102pt; BORDER-TOP-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8" width=136>5</TD><TD class=xl67 style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; WIDTH: 73pt; BORDER-TOP-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8" width=97>POTAPIGG</TD><TD class=xl73 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; BORDER-TOP-COLOR: #3867a6; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 27.75pt" height=37><TD class=xl67 style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; WIDTH: 102pt; BORDER-TOP-COLOR: #d4d0c8; HEIGHT: 27.75pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8" width=136 height=37>OSMIIL20 1</TD><TD class=xl71 style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; WIDTH: 102pt; BORDER-TOP-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8" width=136>5</TD><TD class=xl67 style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; WIDTH: 73pt; BORDER-TOP-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8" width=97>PANT40I</TD><TD class=xl73 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; BORDER-TOP-COLOR: #3867a6; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 40.5pt" height=54><TD class=xl67 style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; WIDTH: 102pt; BORDER-TOP-COLOR: #d4d0c8; HEIGHT: 40.5pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8" width=136 height=54>RAPID INTUBATION</TD><TD class=xl71 style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; WIDTH: 102pt; BORDER-TOP-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8" width=136>5</TD><TD class=xl67 style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; WIDTH: 73pt; BORDER-TOP-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8" width=97>ZOSY50FR2</TD><TD class=xl73 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; BORDER-TOP-COLOR: #3867a6; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 27.75pt" height=37><TD class=xl67 style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; WIDTH: 102pt; BORDER-TOP-COLOR: #d4d0c8; HEIGHT: 27.75pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8" width=136 height=37>KEPP500T</TD><TD class=xl71 style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; WIDTH: 102pt; BORDER-TOP-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8" width=136>4</TD><TD class=xl67 style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; WIDTH: 73pt; BORDER-TOP-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8" width=97>ACETOL130</TD><TD class=xl73 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; BORDER-TOP-COLOR: #3867a6; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 27.75pt" height=37><TD class=xl67 style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; WIDTH: 102pt; BORDER-TOP-COLOR: #d4d0c8; HEIGHT: 27.75pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8" width=136 height=37>RIFAX200T</TD><TD class=xl71 style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; WIDTH: 102pt; BORDER-TOP-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8" width=136>4</TD><TD class=xl67 style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; WIDTH: 73pt; BORDER-TOP-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8" width=97>NIMOOC30</TD><TD class=xl73 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; BORDER-TOP-COLOR: #3867a6; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: transparent">4.00</TD></TR></TBODY></TABLE>

 

[Tinbendr]

if(countif($a$2:$a$7,c8)>0,b2,"")

 

[MARK858]

If you are using a Countif for only values greater than zero could you not use Index/Match with error checking (or conditional formatting the #N/A out)?

Excel Workbook
	A	B	C	D	I	L
1	Exported Med ID Data Source 1	Exported Med ID Data Source 1 Number of Times Not Availle able	Med ID-	Matched Result From Col B to Med Id in C	2007-10
2	NIMOOC30	6	REFR
3	DIPRVIAL	5	DIPRVIAL	5	5	5
4	MS2	5	POTAPIGG
5	OSMIIL20 1	5	PANT40I
6	RAPID INTUBATION	5	ZOSY50FR2
7	KEPP500T	4	ACETOL130
8	RIFAX200T	4	NIMOOC30	4	6	6
Sheet2