VBA or Excel to Auto Filter

J

JMC57

Board Regular
Joined
Apr 24, 2012
Messages
118
I have a list of numbers referencing an item in column B of sheet 2 that can be found in col A sheet1. I want to auto filter column A in Sheet 1 for rows that contain this number in col A Sheet 1. The number can appear multiple times in column A Sheet 1. <o:p></o:p>
I tried VLook up. However, it does not return each occurrence of the number. There are 6000 rows in sheet 1. An item can appear up to 200 times or not at all. <o:p></o:p>
Hopefully someone can help with a VBA code or excel formula to solve this. <o:p></o:p>
Thanks!<o:p></o:p>
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Sort by date Sort by votes
Thanks- I used the following

=IF(COUNTIF(Sheet2!$A$1:$A$6000,$A2)>=COLUMNS($B2:B2),INDEX(Sheet2!$B$1:$B$6000,SMALL(IF(Sheet2!$A$1:$A$6000=$A2,ROW(Sheet2!$A$1:$A$6000)-ROW(Sheet2!$A$1)+1),COLUMNS($B2:B2))),"")

The only problem is that in when looking for a number such as 3407 from col A Sheet 1 it finds a number tha contains 3407 in this case 5407 and returnds the data. How do I chagne this for an exact match?

Thanks
 
Upvote 0
I am looking for the GCN number from sheet 1 col A in Sheet 2 col A and return results. In sheet 1 B through L. Also, there should be several other items returned other than lidocaine. Thank you for taking the time to look at this.

This is sheet 1

[TABLE="width: 1103"]
<TBODY>[TR]
[TD]GCN</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7801</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]29893</SPAN>[/TD]
[TD]LIDOCAINE 30 ML 2</SPAN>[/TD]
[TD]191306 </SPAN>[/TD]
[TD]50383078130</SPAN>[/TD]
[TD]LIDOCAINE HCL </SPAN>[/TD]
[TD]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. </SPAN>[/TD]
[TD]HOS</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]40646</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]62828</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7990</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]8078</SPAN>[/TD]
[TD]LIDOCAINE HCL 10X5 ML 2</SPAN>[/TD]
[TD]866044 </SPAN>[/TD]
[TD]17478071110</SPAN>[/TD]
[TD]LIDOCAINE HCL </SPAN>[/TD]
[TD]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. </SPAN>[/TD]
[TD]HOS</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]65598</SPAN>[/TD]
[TD]LIDOCAINE HCL 10X5 ML 2</SPAN>[/TD]
[TD]866044 </SPAN>[/TD]
[TD]17478071110</SPAN>[/TD]
[TD]LIDOCAINE HCL </SPAN>[/TD]
[TD]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. </SPAN>[/TD]
[TD]HOS</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]13721</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7857</SPAN>[/TD]
[TD]LIDOCAINE HCL 10X5 ML 2</SPAN>[/TD]
[TD]866044 </SPAN>[/TD]
[TD]17478071110</SPAN>[/TD]
[TD]LIDOCAINE HCL </SPAN>[/TD]
[TD]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. </SPAN>[/TD]
[TD]HOS</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]65392</SPAN>[/TD]
[TD]LIDOCAINE HCL 10X5 ML 2</SPAN>[/TD]
[TD]866044 </SPAN>[/TD]
[TD]17478071110</SPAN>[/TD]
[TD]LIDOCAINE HCL </SPAN>[/TD]
[TD]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. </SPAN>[/TD]
[TD]HOS</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]39498</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]58916</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]44226</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]61667</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]39806</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]52911</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]48618</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]53407</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]48618</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]48557</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]44694</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]11689</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]48541</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]16008</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]64354</SPAN>[/TD]
[TD]LIDOCAINE HCL 10X5 ML 2</SPAN>[/TD]
[TD]866044 </SPAN>[/TD]
[TD]17478071110</SPAN>[/TD]
[TD]LIDOCAINE HCL </SPAN>[/TD]
[TD]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. </SPAN>[/TD]
[TD]HOS</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]38434</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]53473</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]8079</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7905</SPAN>[/TD]
[TD]LIDOCAINE HCL 10X5 ML 2</SPAN>[/TD]
[TD]866044 </SPAN>[/TD]
[TD]17478071110</SPAN>[/TD]
[TD]LIDOCAINE HCL </SPAN>[/TD]
[TD]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. </SPAN>[/TD]
[TD]HOS</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]18368</SPAN>[/TD]
[TD]LIDOCAINE HCL 10X5 ML 2</SPAN>[/TD]
[TD]866044 </SPAN>[/TD]
[TD]17478071110</SPAN>[/TD]
[TD]LIDOCAINE HCL </SPAN>[/TD]
[TD]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. </SPAN>[/TD]
[TD]HOS</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]62658</SPAN>[/TD]
[TD]LIDOCAINE HCL 10X5 ML 2</SPAN>[/TD]
[TD]866044 </SPAN>[/TD]
[TD]17478071110</SPAN>[/TD]
[TD]LIDOCAINE HCL </SPAN>[/TD]
[TD]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. </SPAN>[/TD]
[TD]HOS</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]66373</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7984</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]24456</SPAN>[/TD]
[TD]LIDOCAINE HCL 10X5 ML 2</SPAN>[/TD]
[TD]866044 </SPAN>[/TD]
[TD]17478071110</SPAN>[/TD]
[TD]LIDOCAINE HCL </SPAN>[/TD]
[TD]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. </SPAN>[/TD]
[TD]HOS</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]7858</SPAN>[/TD]
[TD]LIDOCAINE HCL 10X5 ML 2</SPAN>[/TD]
[TD]866044 </SPAN>[/TD]
[TD]17478071110</SPAN>[/TD]
[TD]LIDOCAINE HCL </SPAN>[/TD]
[TD]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. </SPAN>[/TD]
[TD]HOS</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]12076</SPAN>[/TD]
[TD]LIDOCAINE HCL 10X5 ML 2</SPAN>[/TD]
[TD]866044 </SPAN>[/TD]
[TD]17478071110</SPAN>[/TD]
[TD]LIDOCAINE HCL </SPAN>[/TD]
[TD]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. </SPAN>[/TD]
[TD]HOS</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]44695</SPAN>[/TD]
[TD]LIDOCAINE HCL 10X5 ML 2</SPAN>[/TD]
[TD]866044 </SPAN>[/TD]
[TD]17478071110</SPAN>[/TD]
[TD]LIDOCAINE HCL </SPAN>[/TD]
[TD]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. </SPAN>[/TD]
[TD]HOS</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]39105</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]70083</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]67691</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]39106</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]46793</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]31186</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7760</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]23551</SPAN>[/TD]
[TD]LIDOCAINE HCL 10X5 ML 2</SPAN>[/TD]
[TD]866044 </SPAN>[/TD]
[TD]17478071110</SPAN>[/TD]
[TD]LIDOCAINE HCL </SPAN>[/TD]
[TD]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. </SPAN>[/TD]
[TD]HOS</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]48544</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]48543</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7964</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]48547</SPAN>[/TD]
[TD]LIDOCAINE HCL 10X5 ML 2</SPAN>[/TD]
[TD]866044 </SPAN>[/TD]
[TD]17478071110</SPAN>[/TD]
[TD]LIDOCAINE HCL </SPAN>[/TD]
[TD]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. </SPAN>[/TD]
[TD]HOS</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]59670</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]19734</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]62065</SPAN>[/TD]
[TD]LIDOCAINE HCL 10X5 ML 2</SPAN>[/TD]
[TD]866044 </SPAN>[/TD]
[TD]17478071110</SPAN>[/TD]
[TD]LIDOCAINE HCL </SPAN>[/TD]
[TD]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. </SPAN>[/TD]
[TD]HOS</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]30796</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7772</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]45393</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]24055</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7920</SPAN>[/TD]
[TD]LIDOCAINE HCL 10X5 ML 2</SPAN>[/TD]
[TD]866044 </SPAN>[/TD]
[TD]17478071110</SPAN>[/TD]
[TD]LIDOCAINE HCL </SPAN>[/TD]
[TD]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. </SPAN>[/TD]
[TD]HOS</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]7917</SPAN>[/TD]
[TD]LIDOCAINE HCL 10X5 ML 2</SPAN>[/TD]
[TD]866044 </SPAN>[/TD]
[TD]17478071110</SPAN>[/TD]
[TD]LIDOCAINE HCL </SPAN>[/TD]
[TD]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. </SPAN>[/TD]
[TD]HOS</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]7917</SPAN>[/TD]
[TD]LIDOCAINE HCL 10X5 ML 2</SPAN>[/TD]
[TD]866044 </SPAN>[/TD]
[TD]17478071110</SPAN>[/TD]
[TD]LIDOCAINE HCL </SPAN>[/TD]
[TD]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. </SPAN>[/TD]
[TD]HOS</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]7771</SPAN>[/TD]
[TD]LIDOCAINE HCL 10X5 ML 2</SPAN>[/TD]
[TD]866044 </SPAN>[/TD]
[TD]17478071110</SPAN>[/TD]
[TD]LIDOCAINE HCL </SPAN>[/TD]
[TD]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. </SPAN>[/TD]
[TD]HOS</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]7855</SPAN>[/TD]
[TD]LIDOCAINE HCL 10X5 ML 2</SPAN>[/TD]
[TD]866044 </SPAN>[/TD]
[TD]17478071110</SPAN>[/TD]
[TD]LIDOCAINE HCL </SPAN>[/TD]
[TD]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. </SPAN>[/TD]
[TD]HOS</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]7856</SPAN>[/TD]
[TD]LIDOCAINE HCL 10X5 ML 2</SPAN>[/TD]
[TD]866044 </SPAN>[/TD]
[TD]17478071110</SPAN>[/TD]
[TD]LIDOCAINE HCL </SPAN>[/TD]
[TD]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. </SPAN>[/TD]
[TD]HOS</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]38587</SPAN>[/TD]
[TD]LIDOCAINE HCL 10X5 ML 2</SPAN>[/TD]
[TD]866044 </SPAN>[/TD]
[TD]17478071110</SPAN>[/TD]
[TD]LIDOCAINE HCL </SPAN>[/TD]
[TD]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. </SPAN>[/TD]
[TD]HOS</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]7985</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7986</SPAN>[/TD]
[TD]LIDOCAINE HCL 10X5 ML 2</SPAN>[/TD]
[TD]866044 </SPAN>[/TD]
[TD]17478071110</SPAN>[/TD]
[TD]LIDOCAINE HCL </SPAN>[/TD]
[TD]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. </SPAN>[/TD]
[TD]HOS</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]7986</SPAN>[/TD]
[TD]LIDOCAINE HCL 10X5 ML 2</SPAN>[/TD]
[TD]866044 </SPAN>[/TD]
[TD]17478071110</SPAN>[/TD]
[TD]LIDOCAINE HCL </SPAN>[/TD]
[TD]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. </SPAN>[/TD]
[TD]HOS</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]47612</SPAN>[/TD]
[TD]LIDOCAINE HCL 10X5 ML 2</SPAN>[/TD]
[TD]866044 </SPAN>[/TD]
[TD]17478071110</SPAN>[/TD]
[TD]LIDOCAINE HCL </SPAN>[/TD]
[TD]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. </SPAN>[/TD]
[TD]HOS</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]26869</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]61667</SPAN>[/TD]
[TD]LIDOCAINE HCL 10X5 ML 2</SPAN>[/TD]
[TD]866044 </SPAN>[/TD]
[TD]17478071110</SPAN>[/TD]
[TD]LIDOCAINE HCL </SPAN>[/TD]
[TD]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. </SPAN>[/TD]
[TD]HOS</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]48554</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]20845</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LIDOCAINE HCL 10X5 ML 2</SPAN>[/TD]
[TD]866044 </SPAN>[/TD]
[TD]17478071110</SPAN>[/TD]
[TD]LIDOCAINE HCL </SPAN>[/TD]
[TD]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. </SPAN>[/TD]
[TD]HOS</SPAN>[/TD]
[/TR]
[TR]
[TD]SHEET 2
[TABLE="width: 588"]
<COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 149pt; mso-width-source: userset; mso-width-alt: 7277" width=199><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 143pt; mso-width-source: userset; mso-width-alt: 6948" width=190><COL style="WIDTH: 104pt; mso-width-source: userset; mso-width-alt: 5046" width=138><COL style="WIDTH: 48pt" span=2 width=64><TBODY>[TR]
[TD="class: xl67, width: 64, bgcolor: #00b0f0"]GCN Number[/TD]
[TD="class: xl65, width: 199, bgcolor: #00b0f0"]RX Item Desc[/TD]
[TD="class: xl65, width: 64, bgcolor: #00b0f0"]RX Item Num[/TD]
[TD="class: xl65, width: 190, bgcolor: #00b0f0"]NDC Current Code[/TD]
[TD="class: xl65, width: 138, bgcolor: #00b0f0"]USAN Generic Name[/TD]
[TD="class: xl65, width: 64, bgcolor: #00b0f0"]AHFS Therapeutic Code - Tier 1[/TD]
[TD="class: xl65, width: 64, bgcolor: #00b0f0"]LOB Code[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]3407[/TD]
[TD="bgcolor: transparent"]LIDOCAINE 30 ML 2[/TD]
[TD="bgcolor: transparent"]191306 [/TD]
[TD="bgcolor: transparent"]50383078130[/TD]
[TD="bgcolor: transparent"]LIDOCAINE HCL [/TD]
[TD="bgcolor: transparent"]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. [/TD]
[TD="bgcolor: transparent"]HOS[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]3407[/TD]
[TD="bgcolor: transparent"]LIDOCAINE 30 ML 2[/TD]
[TD="bgcolor: transparent"]191306 [/TD]
[TD="bgcolor: transparent"]50383078130[/TD]
[TD="bgcolor: transparent"]LIDOCAINE HCL [/TD]
[TD="bgcolor: transparent"]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. [/TD]
[TD="bgcolor: transparent"]HOS[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]3407[/TD]
[TD="bgcolor: transparent"]LIDOCAINE 30 ML 2[/TD]
[TD="bgcolor: transparent"]191306 [/TD]
[TD="bgcolor: transparent"]50383078130[/TD]
[TD="bgcolor: transparent"]LIDOCAINE HCL [/TD]
[TD="bgcolor: transparent"]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. [/TD]
[TD="bgcolor: transparent"]HOS[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]3407[/TD]
[TD="bgcolor: transparent"]LIDOCAINE HCL 10X5 ML 2[/TD]
[TD="bgcolor: transparent"]866044 [/TD]
[TD="bgcolor: transparent"]17478071110[/TD]
[TD="bgcolor: transparent"]LIDOCAINE HCL [/TD]
[TD="bgcolor: transparent"]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. [/TD]
[TD="bgcolor: transparent"]HOS[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]3407[/TD]
[TD="bgcolor: transparent"]LIDOCAINE HCL 10X5 ML 2[/TD]
[TD="bgcolor: transparent"]866044 [/TD]
[TD="bgcolor: transparent"]17478071110[/TD]
[TD="bgcolor: transparent"]LIDOCAINE HCL [/TD]
[TD="bgcolor: transparent"]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. [/TD]
[TD="bgcolor: transparent"]HOS[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]3407[/TD]
[TD="bgcolor: transparent"]LIDOCAINE HCL 10X5 ML 2[/TD]
[TD="bgcolor: transparent"]866044 [/TD]
[TD="bgcolor: transparent"]17478071110[/TD]
[TD="bgcolor: transparent"]LIDOCAINE HCL [/TD]
[TD="bgcolor: transparent"]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. [/TD]
[TD="bgcolor: transparent"]HOS[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]3407[/TD]
[TD="bgcolor: transparent"]LIDOCAINE HCL 10X5 ML 2[/TD]
[TD="bgcolor: transparent"]866044 [/TD]
[TD="bgcolor: transparent"]17478071110[/TD]
[TD="bgcolor: transparent"]LIDOCAINE HCL [/TD]
[TD="bgcolor: transparent"]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. [/TD]
[TD="bgcolor: transparent"]HOS[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]7739[/TD]
[TD="bgcolor: transparent"]SOD CHL 15 ML 5[/TD]
[TD="bgcolor: transparent"]698498 [/TD]
[TD="bgcolor: transparent"]17478062312[/TD]
[TD="bgcolor: transparent"]SODIUM CHLORIDE [/TD]
[TD="bgcolor: transparent"]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. [/TD]
[TD="bgcolor: transparent"]HOS[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]7739[/TD]
[TD="bgcolor: transparent"]SOD CHL 15 ML 5[/TD]
[TD="bgcolor: transparent"]698498 [/TD]
[TD="bgcolor: transparent"]17478062312[/TD]
[TD="bgcolor: transparent"]SODIUM CHLORIDE [/TD]
[TD="bgcolor: transparent"]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. [/TD]
[TD="bgcolor: transparent"]HOS[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]7739[/TD]
[TD="bgcolor: transparent"]SOD CHL 15 ML 5[/TD]
[TD="bgcolor: transparent"]698498 [/TD]
[TD="bgcolor: transparent"]17478062312[/TD]
[TD="bgcolor: transparent"]SODIUM CHLORIDE [/TD]
[TD="bgcolor: transparent"]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. [/TD]
[TD="bgcolor: transparent"]HOS[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]7751[/TD]
[TD="bgcolor: transparent"]GONAK 15 ML 2.5[/TD]
[TD="bgcolor: transparent"]862870 [/TD]
[TD="bgcolor: transparent"]17478006412[/TD]
[TD="bgcolor: transparent"]HYPROMELLOSE [/TD]
[TD="bgcolor: transparent"]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. [/TD]
[TD="bgcolor: transparent"]HOS[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]7751[/TD]
[TD="bgcolor: transparent"]GONAK 15 ML 2.5[/TD]
[TD="bgcolor: transparent"]862870 [/TD]
[TD="bgcolor: transparent"]17478006412[/TD]
[TD="bgcolor: transparent"]HYPROMELLOSE [/TD]
[TD="bgcolor: transparent"]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. [/TD]
[TD="bgcolor: transparent"]HOS[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]7751[/TD]
[TD="bgcolor: transparent"]GONAK 15 ML 2.5[/TD]
[TD="bgcolor: transparent"]862870 [/TD]
[TD="bgcolor: transparent"]17478006412[/TD]
[TD="bgcolor: transparent"]HYPROMELLOSE [/TD]
[TD="bgcolor: transparent"]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. [/TD]
[TD="bgcolor: transparent"]HOS[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]7751[/TD]
[TD="bgcolor: transparent"]GONAK 15 ML 2.5[/TD]
[TD="bgcolor: transparent"]862870 [/TD]
[TD="bgcolor: transparent"]17478006412[/TD]
[TD="bgcolor: transparent"]HYPROMELLOSE [/TD]
[TD="bgcolor: transparent"]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. [/TD]
[TD="bgcolor: transparent"]HOS[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]7751[/TD]
[TD="bgcolor: transparent"]GONAK 15 ML 2.5[/TD]
[TD="bgcolor: transparent"]862870 [/TD]
[TD="bgcolor: transparent"]17478006412[/TD]
[TD="bgcolor: transparent"]HYPROMELLOSE [/TD]
[TD="bgcolor: transparent"]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. [/TD]
[TD="bgcolor: transparent"]HOS[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]7751[/TD]
[TD="bgcolor: transparent"]GONAK 15 ML 2.5[/TD]
[TD="bgcolor: transparent"]862870 [/TD]
[TD="bgcolor: transparent"]17478006412[/TD]
[TD="bgcolor: transparent"]HYPROMELLOSE [/TD]
[TD="bgcolor: transparent"]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. [/TD]
[TD="bgcolor: transparent"]HOS[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]7751[/TD]
[TD="bgcolor: transparent"]GONAK 15 ML 2.5[/TD]
[TD="bgcolor: transparent"]862870 [/TD]
[TD="bgcolor: transparent"]17478006412[/TD]
[TD="bgcolor: transparent"]HYPROMELLOSE [/TD]
[TD="bgcolor: transparent"]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. [/TD]
[TD="bgcolor: transparent"]HOS[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]7751[/TD]
[TD="bgcolor: transparent"]GONAK 15 ML 2.5[/TD]
[TD="bgcolor: transparent"]862870 [/TD]
[TD="bgcolor: transparent"]17478006412[/TD]
[TD="bgcolor: transparent"]HYPROMELLOSE [/TD]
[TD="bgcolor: transparent"]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. [/TD]
[TD="bgcolor: transparent"]HOS[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]7751[/TD]
[TD="bgcolor: transparent"]GONIOVISC 15 ML 2.5[/TD]
[TD="bgcolor: transparent"]278015 [/TD]
[TD="bgcolor: transparent"]17238061015[/TD]
[TD="bgcolor: transparent"]HYPROMELLOSE [/TD]
[TD="bgcolor: transparent"]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. [/TD]
[TD="bgcolor: transparent"]HOS[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]7751[/TD]
[TD="bgcolor: transparent"]GONIOVISC 15 ML 2.5[/TD]
[TD="bgcolor: transparent"]278015 [/TD]
[TD="bgcolor: transparent"]17238061015[/TD]
[TD="bgcolor: transparent"]HYPROMELLOSE [/TD]
[TD="bgcolor: transparent"]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. [/TD]
[TD="bgcolor: transparent"]HOS[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]7751[/TD]
[TD="bgcolor: transparent"]GONIOVISC 15 ML 2.5[/TD]
[TD="bgcolor: transparent"]278015 [/TD]
[TD="bgcolor: transparent"]17238061015[/TD]
[TD="bgcolor: transparent"]HYPROMELLOSE [/TD]
[TD="bgcolor: transparent"]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. [/TD]
[TD="bgcolor: transparent"]HOS[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]7751[/TD]
[TD="bgcolor: transparent"]GONIOVISC 15 ML 2.5[/TD]
[TD="bgcolor: transparent"]278015 [/TD]
[TD="bgcolor: transparent"]17238061015[/TD]
[TD="bgcolor: transparent"]HYPROMELLOSE [/TD]
[TD="bgcolor: transparent"]52 - EYE, EAR, NOSE AND THROAT (EENT) PREPS. [/TD]
[TD="bgcolor: transparent"]HOS[/TD]
[/TR]
</TBODY>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL><COL></COLGROUP>[/TABLE]
 
Upvote 0
Yes- But is returing the value of 3407. I assume it is getting this form 5347 in sheet 1
 
Upvote 0
You must log in or register to reply here.

Similar threads

R
  • Question Question
Help auto filtering dynamic data table
Replies
1
Views
138
russelldt
R
A
  • Solved
Alternative to FILTER function in Excel 2010?
Replies
3
Views
453
Fluff
Fluff
J
  • Question Question
VBA to update formula using excel listing
Replies
6
Views
258
jhod917
J
T
  • Solved
How to return comma separated data (already set up) and return data into separately (matched) cells
Replies
3
Views
102
Fluff
Fluff
Q
  • Question Question
Macro needed to insert 4 rows in table, copy data from above, copy data from another sheet and paste special (transpose values) to those new rows...re
Replies
1
Views
229
sijpie
sijpie

Forum statistics

Threads
1,223,231
Messages
6,170,885
Members
452,364
Latest member
springate

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top