Helo data extrating

Solved/Closed
Sailesh - Apr 19, 2010 at 02:19 AM
 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

2 replies

Have you tried Vlookup?
0
kaiyasit Posts 30 Registration date Sunday August 9, 2009 Status Member Last seen April 20, 2010 12
Apr 20, 2010 at 01:04 AM
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))
0
thank you for your help. it was wonderful.
0