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
> >
> > -------**--------
> >
Similar Threads
