Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
combine data into third sheet
Hi..
I have data in 2 sheets which i want it to be displayed in the third sheet. Please suggest me how to proceed with this... ------**------ Example : Sheet 1: Sheet 2 : No Name1 No Name2 1 abc 1 efg 2 eds 2 xyz 4 def 3 aaa 5 dss 6 ddd The Result should be : Sheet 3 : No Name1 Name2 1 abc efg 2 eds xyz 3 aaa 4 def 5 dss 6 ddd -------**-------- |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
combine data into third sheet
you can use a vlookup.
Col.a=your numbers. Col.b=formulas Name1 1 =IF(ISERROR(VLOOKUP($A2,Sheet1!$A$2:$B$5,2,FALSE)) ,"",VLOOKUP($A2,Sheet1!$A$2:$B$5,2,FALSE)) 2 =IF(ISERROR(VLOOKUP($A3,Sheet1!$A$2:$B$5,2,FALSE)) ,"",VLOOKUP($A3,Sheet1!$A$2:$B$5,2,FALSE)) 3 =IF(ISERROR(VLOOKUP($A4,Sheet1!$A$2:$B$5,2,FALSE)) ,"",VLOOKUP($A4,Sheet1!$A$2:$B$5,2,FALSE)) 4 =IF(ISERROR(VLOOKUP($A5,Sheet1!$A$2:$B$5,2,FALSE)) ,"",VLOOKUP($A5,Sheet1!$A$2:$B$5,2,FALSE)) 5 =IF(ISERROR(VLOOKUP($A6,Sheet1!$A$2:$B$5,2,FALSE)) ,"",VLOOKUP($A6,Sheet1!$A$2:$B$5,2,FALSE)) 6 =IF(ISERROR(VLOOKUP($A7,Sheet1!$A$2:$B$5,2,FALSE)) ,"",VLOOKUP($A7,Sheet1!$A$2:$B$5,2,FALSE)) "Sri" wrote: Hi.. I have data in 2 sheets which i want it to be displayed in the third sheet. Please suggest me how to proceed with this... ------**------ Example : Sheet 1: Sheet 2 : No Name1 No Name2 1 abc 1 efg 2 eds 2 xyz 4 def 3 aaa 5 dss 6 ddd The Result should be : Sheet 3 : No Name1 Name2 1 abc efg 2 eds xyz 3 aaa 4 def 5 dss 6 ddd -------**-------- |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
combine data into third sheet
Hi Lynn,
Thank you very much for your help... It saved me many hours .... In my example I just gave you 2 columns resulting 3 in third sheet... my doubt is .. 1. Is there any way to pull the Number column also from both sheets using formula if possible unique. ( Now I have copied from 2 sheets and filtered it... is there any better way) 2. I have 30 columns withof such type in each sheet and sheets may increase everymonth. So instead of copying the formula in each coluumn , Is there any short way. Thanks in advance!!!! "Lynn Perplexed" wrote: you can use a vlookup. Col.a=your numbers. Col.b=formulas Name1 1 =IF(ISERROR(VLOOKUP($A2,Sheet1!$A$2:$B$5,2,FALSE)) ,"",VLOOKUP($A2,Sheet1!$A$2:$B$5,2,FALSE)) 2 =IF(ISERROR(VLOOKUP($A3,Sheet1!$A$2:$B$5,2,FALSE)) ,"",VLOOKUP($A3,Sheet1!$A$2:$B$5,2,FALSE)) 3 =IF(ISERROR(VLOOKUP($A4,Sheet1!$A$2:$B$5,2,FALSE)) ,"",VLOOKUP($A4,Sheet1!$A$2:$B$5,2,FALSE)) 4 =IF(ISERROR(VLOOKUP($A5,Sheet1!$A$2:$B$5,2,FALSE)) ,"",VLOOKUP($A5,Sheet1!$A$2:$B$5,2,FALSE)) 5 =IF(ISERROR(VLOOKUP($A6,Sheet1!$A$2:$B$5,2,FALSE)) ,"",VLOOKUP($A6,Sheet1!$A$2:$B$5,2,FALSE)) 6 =IF(ISERROR(VLOOKUP($A7,Sheet1!$A$2:$B$5,2,FALSE)) ,"",VLOOKUP($A7,Sheet1!$A$2:$B$5,2,FALSE)) "Sri" wrote: Hi.. I have data in 2 sheets which i want it to be displayed in the third sheet. Please suggest me how to proceed with this... ------**------ Example : Sheet 1: Sheet 2 : No Name1 No Name2 1 abc 1 efg 2 eds 2 xyz 4 def 3 aaa 5 dss 6 ddd The Result should be : Sheet 3 : No Name1 Name2 1 abc efg 2 eds xyz 3 aaa 4 def 5 dss 6 ddd -------**-------- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I combine identicle worksheets into one sheet | Excel Discussion (Misc queries) | |||
Combine all the data's from different sheet to one sheet. | Excel Worksheet Functions | |||
How do I combine data from several sheets into one main sheet? | Excel Worksheet Functions | |||
how to combine two similiar sheet | Excel Worksheet Functions | |||
Combine multiple sheets into one sheet? | Excel Discussion (Misc queries) |