Compare columns and return date

Jeni - Oct 20, 2010 at 03:32 PM
 RayH - Oct 20, 2010 at 09:17 PM

I have 2 excel files: Book1.xls and Book2.xls. I want to look through column B in Book1 and column D in Book2 and find the rows that match where column B contents is the same as column D contents. If B and D match i want to return the date that is in that same row from Book1 into a new column in Book2.

1 reply

Do some reading up of the Excel function VLOOKUP. There are many examples in this forum.