Help with formula

[N SHIVKUMAR]

Good Morning Gurus
I am a recently retired bank officer. I have been following the forum and learnt a lot Thanx a lot.
I have an issue :
1. Sheet1 : Column A has records which are duplicate also.
2. Sheet2 : Column A has unique records and Column B has project description
I want records of Sheet2 Column B to be shown in Sheet1 Column B
Thanking you all in anticipation of a quick reply
Regards

 

[AliGW]

Try this:

=VLOOKUP(A2,Sheet2!$A$2:$B$8512,2,0)

This will remove #N/A errors:

=IFNA(VLOOKUP(A2,Sheet2!$A$2:$B$8512,2,0),"")

 

[N SHIVKUMAR]

Thanx a lot Mam

 

[AliGW]

No problem.