EXCEL 2003
It's all good. Thanks for the solution and the prompt responses from both
you and Niek.
"JLatham" wrote:
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.
|