Oops, I screwed up the ISNA variation of the formula, should be:

=IF(ISNA(VLOOKUP(B1,'Sheet2'!$A$1:$B$20,2,FALSE)), "",VLOOKUP(B1,'Sheet2'!$A$1:$B$20,2,FALSE))

"Mike" wrote:

Thanks for the code, but it did not work. My description of what I am trying
to do was inaccurate. I should have said:

I want to take the contents of cells B1 - B11025 on Sheet1, look for a match
on Sheet2 in cells A1 - A20, and return the coresponding text in B1 - B20 on
Sheet2 to cells C1 - C11025 on Sheet1.

Can this be done?

"Niek Otten" wrote:

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.