One way:

In Worksheet 2, cell B1:

=IF(ISNA(MATCH(A1,Sheet1!A:A,FALSE)), "",
VLOOKUP(A1,Sheet1!A:B,2,FALSE))

In article ,
sarahp wrote:

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