I have two work books that have different data. However, three columns are the same. One column is a description, one is a list number and one is a lot number. I know that my lot number is correct in the two workbooks. However, I want to take the list number and description from workbook 2 and whereever the lot number on workbook 1 matches the lot number on workbook 2, take the list number and description from workbook 2 and replace the same corresponding cells on workbook 1 with this data from workbook 2 without changing any other data. I want to do this with each worksheet on workbook 1.

I think I need vlookup but I am just not sure and I want to do this with VB. So explain it differently, I want to look at a number on workbook 1 in column O and find that same number on workbook 2 (any spreadsheet) in column K. Once found, I want to take the information for the same row on workbook 2 columns from columns H and G and put it into workbook 1 (for each spreadsheet) in columns H and I.

Hope this is a good enough explanation. Thanks in advance for any replies.