I am working with 2 excel workbooks. I am copying the company i.d. # in one and pasting it in the right cell in the other. I was wondering if it was possible to create some type of logic formula to do the work for me. In each workbook there is a column for company name, address, city, zipcode and state. Is it possible to make a formula that maybe says, 'if this address # and city in workbook 1 matches this address # and city in workbook 2, then copy and paste this company i.d. # from workbook 2 into this cell in workbook 1.'

Thanks,
J