Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want help to fill data of sheet 2 in sheet 1
Dear Experts:
I wanted to know if by any way I can do this: I have sheet 1 in that two Rows ie( a1=Name and B1 =age) in sheet 2 I want to keep data of some friends ie:(sheet2 a1=Names of people and sheet2 b=age of same people) I want that if I put name in sheet a like RAM in sheet 1 A1 then it should match the name and check the age of same RAM from sheet 2 B data and fill the same in sheet 1 ,B1. Is it possible, pls help me. Thnaks, Das (PUNE) INDIA |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want help to fill data of sheet 2 in sheet 1
On Tue, 22 Jul 2008 01:27:01 -0700, Das (PUNE) <Das
wrote: Dear Experts: I wanted to know if by any way I can do this: I have sheet 1 in that two Rows ie( a1=Name and B1 =age) in sheet 2 I want to keep data of some friends ie:(sheet2 a1=Names of people and sheet2 b=age of same people) I want that if I put name in sheet a like RAM in sheet 1 A1 then it should match the name and check the age of same RAM from sheet 2 B data and fill the same in sheet 1 ,B1. Is it possible, pls help me. Thnaks, Das (PUNE) INDIA Try this formula in cell B1 of sheet1: =VLOOKUP(A1, sheet2!$A$1:$B$100, 2, FALSE) copy this formula down as far as needed in column B. You have to change $B$100 in the formula if you have more than 100 names in sheet2. Hope this helps / Lars-Åke |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"='sheet 1'!D4" auto fill sheet to sheet ='sheet 2'!D4 | Excel Worksheet Functions | |||
Conditionally Fill a sheet row if cell value in another sheet 0 | Excel Worksheet Functions | |||
pull data from sheet two, then fill in the data to sheet one (part | Excel Worksheet Functions | |||
Help!: lead sheet data needs to fill appropriate subject sheets | Excel Worksheet Functions | |||
Help!: lead sheet data needs to fill appropriate subject sheets | Excel Worksheet Functions |