| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
From 1 worksheet to another
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
From 1 worksheet to another
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| automatically appending newly added data on worksheet to a master list worksheet | Links and Linking in Excel | |||
| Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
| Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
| copy range on every worksheet (diff names) to a master worksheet (to be created) | Excel Programming | |||
| Attaching a JET database to an Excel Worksheet OR storing large binary data in a worksheet | Excel Programming | |||
Linear Mode
