| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUP Compile/Syntax Error
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 =----- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| compile/syntax error to save active book to new location on networ | Excel Worksheet Functions | |||
| How do I get rid of "Compile error in hidden module" error message | Excel Discussion (Misc queries) | |||
| Vlookup Syntax Error | New Users to Excel | |||
| Syntax Error in VLOOKUP Code | Excel Programming | |||
![Dave D-C[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
