It is working with your help. But could you please help me understand why the below one is not working?

=VLOOKUP(A2,Sheet1!$A$2:$C$5,3,0)

Regards

Rakesh