Hi,
I made a mistake last time ....sorry
I have two separates excel workbooks ( not worksheets!!).
Workbook no 1 which has several columns : A ( XP numbers) to O
Workbook no 2 which has two columns : A ( XP numbers) and B ( DOI numbers)
PS: both workbooks have column A in common ( XP numbers)
I am trying to extract the data from the column B ( DOI numbers ) of workbook no 2 and insert them into workbook no 1 ONLY when the data from column A ( XP numbers) match !
Can anyone help me with the formula?
Step by step ...
Also it is possible to automatically repeat the same formula accross several other workbooks ?:
..... with Workbook no 3 and 4 and 5 ...etc ....( Identical to woorkbook no 2) : has two columns : A ( XP numbers) and B ( DOI numbers)
Many thanks
Sarah
Bookmarks