helo data extrating Solved/Closed

Question

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

Trowa · Answer

Have you tried Vlookup?

kaiyasit · Answer

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

Helo data extrating

2 responses

Similar discussions

Subscribe To Our Newsletter!