Or maybe:

Sheet3.Cells(5, 8) = _
"=IF(ISNA(VLookup(Sheet2!a2,Sheet1!A2:B4, 2, 0))," & _
"""""," & _
"VLookup(Sheet2!a2, Sheet1!A2:B4, 2, 0))"

JimFor wrote:
Thanks for the info. I'll work around the limitation.

Chip wrote:
Sheet3.Cells(5, 8) =
IIf(IsError(Application.VLookup(Sheet2.Cells(2, 1), _
Worksheets("Sheet1").Range("A2:B4"), 2, 0)), "", _
Application.VLookup(Worksheets("Sheet1").Range("A2 :B4"), 2,
0))


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---


-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
http://www.newsfeed.com The #1 Newsgroup Service in the World!
-----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =-----