Excel Macro Search

Closed
cherryxc0ke - Sep 1, 2009 at 03:29 PM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Sep 3, 2009 at 03:03 AM
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

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Sep 3, 2009 at 03:03 AM
use VLOOKUP(lookup_value,table_array,col_index_num,false)
0