combine data into third sheet

S

Sri

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

-------**--------
 
L

Lynn Perplexed

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))
 
S

Sri

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!!!!
 

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

Top