| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
match between worksheets
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
match between worksheets
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. -- Thanks, Kevin "confused!!" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set up worksheets to match? | Setting up and Configuration of Excel | |||
| trying to match text in 2 worksheets | Excel Worksheet Functions | |||
| How to match to Worksheets | Excel Worksheet Functions | |||
| Look for match on two worksheets | Excel Worksheet Functions | |||
| Can you match records from two different worksheets | Excel Worksheet Functions | |||
Linear Mode
