matching data between two worksheets

[DanielG]

Hi, I have data in two different 2 worksheets. Worksheet A contains names and registration dates, Worksheet B contains a huge list of names (a roster of employees). What I need to see is if a name from Worksheet A (in say..column A) matches a name in Worksheet B (column B), then the registration date for that person (found in Worksheet A) should be written to Worksheet B next to the matching name (column C). So if there is no match, then no date will be written. Thanks for your help!!

 

[big_mac]

If sheetB cell B2 has the first name to match with sheetA column A with the dates in Column B then either of these formulas will work if placed in SheetB cell C2.
=VLOOKUP(SheetB!B2,SheetA!A3:B7,2,FALSE)
=INDIRECT("sheetA!b"&MATCH(SheetB!B2,SheetA!A2:A7,0))

to not show the errors if there is no matching names just do the following which is the same formula just longer because of error handling.

IF(ISERROR(VLOOKUP(SheetB!B2,SheetA!A3:B7,2,FALSE)),"",VLOOKUP(SheetB!B2,SheetA!A3:B7,2,FALSE))
=IF(ISERROR(INDIRECT("sheetA!b"&MATCH(SheetB!B2,SheetA!A2:A7,0))),"",INDIRECT("sheetA!b"&MATCH(SheetB!B2,SheetA!A2:A7,0)))