matching text

[Bob]

On sheet 1, I have Col A with unique references that
matches a description in col B. On sheet 2 I type in a
unique reference in col C , so I need a formula in col
B sheet 2 that will get the right description to each
unique reference.
Any help would be welcomed.
Bob

 

[Vasant Nanavati]

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

Adjust rows and columns to suit.