On Sheet1:

=INDEX(B1:B20,MATCH(A2,Sheet2!A1:A20,0))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Mike" wrote in message
...
Can I take the contents ("WD4") of a cell (A2)on Sheet1, look for a match
of
the code ("WD4") on Sheet2 in cells A1-A20, and return the coresponding
text
in B1-B20 on Sheet2 to cell B2 on Sheet1.