need to do vlookup between two column

[samdesouza]

Title	Firstname	lastname	Phone no	tel no	Add1
Mrs	Joan	Bodenham	1746763108	1752704853	29 Northgate
Miss	Evelyn	Paterson	175022299	1737357481	40 Shawburn Road
Mrs	Lucinda	Ferguson	175021844	1442391815	1 Heatherlie Park
Mr	Christopher	Down	1752704853	1738634895	46 Dayton Close
Mrs	Cheryl	Hughes	1737357481	1738622929	53 Warren Road
Mrs	Linda	Wheeler	1442391815	1738787705	100 Allandale
Mr	Alastair	Carter	1738634895	175032268	42 Anderson Drive
Mrs	Agnes	Manattini	1738622929	1748884233	37 Muirton Bank
Mrs	Patricia	Stewart	1738787705	1748822884	7 Tulliebelton Place
Mrs	Sandra	Grieve	175032268	1748821346	School House
Mr	John	Calvert	1748884233		Heatherdale Bungalow
Mrs	J	Turnbull	1748822884		Low Whashton Springs
Mrs	Mary	Cherry	1748821346		56 Bargate
Mr	John	Durcan	1745570536		19 Maes Y Foel
Mrs	Margaret	Taylor	1737822505		10C Trindles Road
Mrs	E	Dean	1745855076		5 Ffordd Penrhwylfa
Mr	Michael	Henry	1752863263		4 Laburnum Drive

<colgroup><col><col><col><col span="2"><col></colgroup><tbody>
</tbody>

<colgroup><col><col><col><col span="2"><col></colgroup><tbody></tbody>

Need to do vlookup between phone no and tel no
the number will match i need that data only and rest of the data i need to delete from phone no

 

[Andrew Poulsom]

What results do you expect from your sample data exactly?

 

[samdesouza]

I have data like in different file (1) like 27000 Customer number with name and address and in another file (2)17000 customer number i just need to take out this 17000 number with customer name and address from another file 1 which in 27000 number
File 1

Title	First name	Last name	Phone No	Add1	Add2	Add3	Town	County	Postcode
Mrs	Joan	Bodenham	1746763108	29 Northgate	Null	Null	Bridgnorth	Shropshire	WV16 4ET
Miss	Evelyn	Paterson	175022299	40 Shawburn Road	Null	Null	Selkirk	Scottish Borders	TD7 4HW
Mrs	Lucinda	Ferguson	175021844	1 Heatherlie Park	Null	Null	Selkirk	Scottish Borders	TD7 5AL
Mr	Christopher	Down	1752704853	46 Dayton Close	Null	Null	Plymouth	Devon	PL6 5DX
Mrs	Cheryl	Hughes	1737357481	53 Warren Road	Null	Null	Banstead	Surrey	SM7 1LG
Mrs	Linda	Wheeler	1442391815	100 Allandale	Null	Null	Hemel Hempstead	Hertfordshire	HP2 5AT
Mr	Alastair	Carter	1738634895	42 Anderson Drive	Null	Null	Perth	Perth And Kinross	PH1 1JX
Mrs	Agnes	Manattini	1738622929	37 Muirton Bank	Null	Null	Perth	Perth And Kinross	PH1 5DW
Mrs	Patricia	Stewart	1738787705	7 Tulliebelton Place	Bankfoot	Null	Perth	Perth And Kinross	PH1 4BU
Mrs	Sandra	Grieve	175032268	School House	Ashkirk	Null	Selkirk	Scottish Borders	TD7 4NY
Mr	John	Calvert	1748884233	Heatherdale Bungalow	Reeth	Null	Richmond	North Yorkshire	DL11 6TQ
Mrs	J	Turnbull	1748822884	Low Whashton Springs	Whashton	Null	Richmond	North Yorkshire	DL11 7JS
Mrs	Mary	Cherry	1748821346	56 Bargate	Null	Null	Richmond	North Yorkshire	DL10 4QY
Mr	John	Durcan	1745570536	19 Maes Y Foel	Dyserth	Null	Rhyl	Denbighshire	LL18 6AP
Mrs	Margaret	Taylor	1737822505	10C Trindles Road	South Nutfield	Null	Redhill	Surrey	RH1 4JN
Mrs	E	Dean	1745855076	5 Ffordd Penrhwylfa	Null	Null	Prestatyn	Denbighshire	LL19 8AD
Mr	Michael	Henry	1752863263	4 Laburnum Drive	Wembury	Null	Plymouth	Devon	PL9 0LQ
Mr	Clifford	Roycroft	1745592074	17 Ffordd Ffynnon	Rhuddlan	Null	Rhyl	Denbighshire	LL18 2SP
Mr	Laurence	Allison	1748884366	1 Cogden Hall	Grinton	Null	Richmond	North Yorkshire	DL11 6HT
Mrs	Phillipa	Edmunds	1753645670	34 Sefton Close	Stoke Poges	Null	Slough	Buckinghamshire	SL2 4LJ

<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

and file 2

1752704853
1737357481
1442391815
1738634895
1738622929
1738787705
175032268
1748884233
1748822884
1748821346
1745570536
1737822505

<colgroup><col></colgroup><tbody>
</tbody>

 

[Andrew Poulsom]

It sound like you need INDEX/MATCH. Here's a tutorial:

http://www.contextures.com/xlFunctions03.html