From 1 worksheet to another

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

vernalGreens@gmail.com - 24 Jan 2006 05:01 GMT

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?

Reply to this Message

Gary Keramidas - 24 Jan 2006 05:17 GMT

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)

Signature

Gary

> I've two excel worksheets.
>
[quoted text clipped - 15 lines]
> How can I populate the father's name column in worksheetB using the
> info from worksheetA?

Reply to this Message

Gary Keramidas - 24 Jan 2006 05:20 GMT

sorry
if your data is in A2- A6 on sheet1
should be

if your data is in A2- B6 on sheet1

Signature

Gary

> 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
[quoted text clipped - 20 lines]
>> How can I populate the father's name column in worksheetB using the
>> info from worksheetA?

Reply to this Message