From 1 worksheet to another
sorry
if your data is in A2- A6 on sheet1
should be
if your data is in A2- B6 on sheet1
--
Gary
"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
if your data is in A2- A6 on sheet1 and you want to lookup column A from sheet
2, put a name in a2 and this formula in b3 on sheet2
=VLOOKUP(A2,Sheet1!A2:B6,2,FALSE)
--
Gary
wrote in message
ups.com...
I've two excel worksheets.
worsheetA has names of people and their father's name.
Name Father's Name
A AsDad
B BsDad
C CsDad
D DsDad
E EsDad
I've taken some of the names from worksheetA into worksheetB (manual
selection)
WorksheetB
Name Father's Name
B
D
How can I populate the father's name column in worksheetB using the
info from worksheetA?
|