need to do vlookup in different sheet

[samdesouza]

Hello,
please could you help me for doing vlookup in two different sheet like in
Sheet 1

Title	Firstname	lastname	Phone no	Add1
Mrs	Joan	Bodenham	1746763108	29 Northgate
Miss	Evelyn	Paterson	175022299	40 Shawburn Road
Mrs	Lucinda	Ferguson	175021844	1 Heatherlie Park
Mr	Christopher	Down	1752704853	46 Dayton Close
Mrs	Cheryl	Hughes	1737357481	53 Warren Road
Mrs	Linda	Wheeler	1442391815	100 Allandale
Mr	Alastair	Carter	1738634895	42 Anderson Drive
Mrs	Agnes	Manattini	1738622929	37 Muirton Bank

<tbody>
</tbody>

sheet 2

Phone no
1746763108
175022299
175021844
1752704853
1737357481
1442391815
1738634895
1738622929
1738787705
175032268
1748884233
1748822884
1748821346
1745570536
1737822505
1745855076
1752863263
1745592074
1748884366 i just need to know how to check in sheet 1 which which number is available from sheet 2

<tbody>
</tbody>

 

[etaf]

you dont need a vlookup - you could use a countif()

what would you like to see in sheet1

=vlookup(d2, sheet2!$A$2:$A$100,1, false)

you will see the number returned or a #N/A