Hi,
I have two separates excel worksheets.
Worksheet no 1 which has two columns : A ( XP numbers) and B ( DOI
numbers)
Worksheet no 2 which has several columns : A ( XP numbers) to O
PS: both worksheet have column A in common ( XP numbers)
I am trying to extract the data from the column B ( DOI numbers ) of
worksheet no 1 and insert them into worksheet no 2 ONLY when the data
from column A ( XP numbers) match !
Can anyone help me with the formula?
Step by step ...please.
Many thanks
Sarah
--
sarahp
------------------------------------------------------------------------
sarahp's Profile:
http://www.excelforum.com/member.php...o&userid=27623
View this thread:
http://www.excelforum.com/showthread...hreadid=471403