LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Function Add-in troubleshooting-Vlookup

I use Vlookup extensively and attempted to add a new function, Vlook.

The function should 1) set the 4th argument to false, and 2) return an empty
string if the regular formula would return an error.

#2 is what I'm having a problem with.

Here's my code

Function vlook(cell,range,column)
vlook = Application.WorksheetFunction.vlookup(cell,range,c olumn,FALSE)
if Application.WorksheetFunction.IsError(vlook) then vlook = ""
End Function


The code works for non-errors, however, returns #VALUE! instead of "" if the
formula cannot be resolved.

Help!


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VLookup Troubleshooting #N/A IrishEyes Excel Discussion (Misc queries) 1 January 12th 10 05:56 PM
Troubleshooting David Rogers Excel Discussion (Misc queries) 2 November 26th 08 12:02 PM
Function Troubleshooting Sarah Excel Worksheet Functions 1 June 7th 07 10:28 PM
SUMPRODUCT troubleshooting CathB Excel Worksheet Functions 7 May 10th 06 03:01 PM
troubleshooting Mr. Lucky69 Setting up and Configuration of Excel 0 April 29th 06 08:57 PM


All times are GMT +1. The time now is 08:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"