Previous Topic Next Topic

Compare columns and return date

Closed
Jeni - 20 Oct 2010 à 15:32
 RayH - 20 Oct 2010 à 21:17
Hello,

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.
Related:

1 response

Réponse 1 / 1
RayH
20 Oct 2010 à 21:17
Do some reading up of the Excel function VLOOKUP. There are many examples in this forum.

Similar discussions

WOW equipment return
aakash12345_0667 -
HelpiOS -

1 response
How to Compare two workbooks and see if data has moved or not?
hoosier1851 -
TrowaD -

1 response
Macro to compare sheets(Jan & Feb), highlight the difference, copy the comme
drsuresh26 -
ac3mark -

1 response
Opening a word document in multiple versions
elizas -
closeup22 -

1 response
Compare values in two columns and return the value from third
ramdubai -
keshav -

11 responses