Helo data extrating [Solved/Closed]

- - Latest reply:  Sailesh - Apr 20, 2010 at 01:36 AM
Hello.

I have a File which contains 3 colums Mobile No , Name And Address in Sheet one.

Each file contains approx 500000 data.

in sheet 2 i have approx 10000 mobile numbers only.

Kindly Tell me how to add name and address which should be extracted from sheet 1

eg:

Sheet 1

Mobile no name address
99898989 amit akjdhak jasdhajs
87878787 sam jasfhsjd ihadfsish
87687878 ram jsdfhjksdhf
87878787 sil isudhfsidfg

Sheet 2

Mobile no name address
98789898 ? ?
87878878 ? ?


Please Do Reply it at earliest.

Sailesh
See more 

2 replies

0
Thank you
Have you tried Vlookup?
Posts
30
Registration date
Sunday August 9, 2009
Status
Member
Last seen
April 20, 2010
11
0
Thank you
in the sheet 2 at column "name" use code on below
=IF(ISNA(VLOOKUP(A2,Sheet1!A:B,2,0)),"",VLOOKUP(A2,Sheet1!A:B,2,0))
************************************************************
in the sheet 2 at column "address" use code on below
=IF(ISNA(VLOOKUP(A2,Sheet1!A:C,3,0)),"",VLOOKUP(A2,Sheet1!A:C,3,0))
thank you for your help. it was wonderful.