Database help

[OverklocK]

I have a couple database files that need to be compared. On one list I have name, address, tele, city, state, zip and customer ID. On the other file I have a selective list of customer ID's. I need to get all the criteria of the first file on the second file but only for those selective customer ID's. Can anyone point me in the right direction? Thank you in advance=)

[carsto]

If your comprehensive database can be sorted alphabetically, use the VLOOKUP function

VLOOKUP(lookup_value,table_array,col_index_num,FALSE)

[VBA Noob]

Hi,

These link might help

http://www.contextures.com/xlFunctions02.html

http://www.cpearson.com/excel/duplicat.htm

VBA Noob