How to find specific value on different worksheet?

[aerismel]

Hello everyone. I am working with 2 spreadsheets now. The first spreadsheet is an insurance database, and it has text and numbers in it. The other is a spreadsheet I downloaded from metlife that shows all payments of the current month for their insurance.

Each person has an insurance number, and the thing I need to do, is to check from the metlife's database if that insurance number appears on my database, then if it appears in my database, I need it to add a number on a specific cell in my database. I wonder if this is possible?

With other words, I need to select a value from table 2 and search for it on a specific column in table 1. Then if the value has been found, I need it to add a "1" in another column, and if it is not there, I need it to add a "0". The problem with this is that I would like to make it a bit more automated, because I have more than 200 rows I need to check from table 2. So I don't want to check it one by one. I want it to check it by itself and then see if the value is there. That is the first step I need to learn how to do.

Thank you very much. I hope I have explained it correctly.

[TMS]

Try using VLOOKUP

Regards, TMS