Hi jeevan123,

Welcome to the forum!!

Try this formula in cell B1 of Sheet2 and then copied as required:

=VLOOKUP(A1,Sheet1!A:B,2,FALSE)

Regards,

Robert