Excel Macro Search [Closed]

Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
Hello,

I have a column of 500+ zip codes in Excel. I have another spreadsheet that has 200,000+ names and zip codes. I need a macro that would search for those 500+ zip codes in the spreadsheet and extract the names in another spreadsheet.

How would you go about doing this?

Thanks!

1 reply

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
use VLOOKUP(lookup_value,table_array,col_index_num,false)

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!