Ron..

I have 25 columns in each sheet and there are many sheets too . So is there
any better way to proceed or use the same query in all the columns.
Sri

"Ron@Buy" wrote:

Sri

Paste this into cell B2 of Sheet3:
=IF(ISNA(VLOOKUP(A2,Sheet1!$A$2:$B$100,2,FALSE))," ",VLOOKUP(A2,Sheet1!$A$2:$B$100,2,FALSE))
and copy down ( note I have assumed 99 rows of data - change the 100 to suit
your number of rows)
Copy and paste formula into cell C2 of Sheet3, change Sheet1 to Sheet2 and
copy down to suit your number of rows.
Hope this helps


"Sri" wrote:

Hi ..Thank you very much for responding .... Is there any way to pull the two
columns into 3rd sheet "NO" and "NAME1" ...resulting "NO" , "NAME1","NAME2"
in the third sheet ... Also all the serial numbers may not be same in the
first two sheets .... I am new to excel.... sorry to bother you .. Thank
you...

"KePaHa" wrote:

Under Name1 on sheet 3, something like this should work:

=IF(Sheet1!A1<"", Sheet1!A1, "")

If Sheet1 A1 is empty, then do nothing, otherwise put in here what is in
cell A1.



"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

-------**--------