From 1 worksheet to another

  • Thread starter Thread starter vernalGreens
  • Start date Start date
V

vernalGreens

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?
 
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)
 
sorry
if your data is in A2- A6 on sheet1
should be

if your data is in A2- B6 on sheet1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

401k Spreadsheets help 5
countif using multiple criteria 2
Excel sort column with indirectly referenced dymanic worksheet 1
Need help in comparing two worksheets 1
Will VLOOKUP help here? 4
Linked Tables Manager - Changing Link to Worksheet 3
Refrencing and Linking Worksheets 1
Excel VBA-Worksheet Name length issue while Querying frm another E 2

Back
Top