Name Lookup

pzamory

Board Regular
Joined
May 2, 2002
Messages
122
Good afternoon. I would like to create a sheet (formula) that would scan another sheet for customer name matches.

I would like to have a Master Excel Sheet with the names of companies that I work with (i.e. XYZ Corp)

I receive Excel sheets daily for work that will be done that impacts hundreds of customers. I'd like to be able to match these sheets with my Master sheet to see if any of my customers are impacted. I would rather do this than manually scroll through these sheets (or use a filter) to see if my customers are on the list.

Vlookup? Macro?

Thanks in advance

Note: All the daily work sheets display the customer name in Column A
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Watch MrExcel Video

Forum statistics

Threads
1,096,321
Messages
5,449,704
Members
405,575
Latest member
Masimo85

This Week's Hot Topics

Top