Finding values of one list in another

[Jorge E. Jaramillo]

I have two files, one contains the names of customers and their status
according to some internal criteria (basically OK or Not OK) and has about
4.000 registers and the other file has the names of the customers that are
next to renewal time (about 500 registers).

How do I make Excel to take every name on the Renewal list and compare it to
the names on the Customers list and then producing a list of the matches and
their status?

It doesn't matter how the results are displayed, it could be a mark on a new
column or a new list with the coincidences, whatever

Thanks in advance

Jorge E Jaramillo

 

[zodiac711]

Jorge,

Provided that the name would be identical between the two worksheets, I
believe a VLOOKUP would solve your problem.

If WS1 contains the customer name in column A, and their status in column B,
and WS2 contains the customer name in column A and their renewal time in
column B, and in Column C you wanted to have the status be displayed, it
would be =VLOOKUP(A1,WS2!A:B,2,FALSE)
This would lookup the customer name in cell A1, and then find the
corresponding match in WS2 and provide you with the value that is showing in
column B.

 

[Jorge E. Jaramillo]

Thank you Zodiac711 I tried vlookup and it kind of does the trick,
unfortunately the databases have slight differences in the names and the
results are less than optimal, but I think there is nothing to solve this.

Thanks anyway.