match between worksheets

[confused!!]

I have three worksheets with similar pieces of information never formatted
the same, but need to match.



Exp 1: worksheet 1
Full Name JDE OW

GERARD ZITTOUN ZITTOUN
GERARD ZITTOUN TSZITTOUN
NATASHA MOTON MOTON4
NATASHA MOTON MOTON3
NATASHA MOTON MOTON2
NATASHA MOTON MOTON
REMI VILLENEUVE ZVILLENE
REMI VILLENEUVE TSZVILLENE


Exp 2: worksheet 2

Full Name AS400
Gerard Zittoun Zittoun
NATASHA MOTON Moton

Exp 3: worksheet 3

Full Name NT
Gerard Zittoun Zittoun
NATASHA MOTON Moton
REMI VILLENEUVE ZVILLENE

Exp 4: end result (regardless if it is in same worksheet or new one)



Full Name NT JDE OW AS400
GERARD ZITTOUN Zittoun ZITTOUN Zittoun
GERARD ZITTOUN TSZITTOUN
NATASHA MOTON Moton MOTON4 Moton
NATASHA MOTON MOTON3
NATASHA MOTON MOTON2
NATASHA MOTON MOTON
REMI VILLENEUVE ZVILLENE ZVILLENE
TSZVILLENE

 

[AFSSkier]

A VLOOKUP should work for you. As long as the 1st column has the common match
reference your looking for. VLOOKUP Looks in the first column of your data
source (array) and moves across the row to return the value of a cell
(column# 2),

Before you begin, define (name) the sheet or reference area of your data.
In this example I defined the sheet2 "worksheet2".

In D2 =VLOOKUP(A2,worksheet2,2,FALSE)

If this as clear as mud, read the help on VLOOKUPs.