Bob Phillips
12/13/2006 4:14:00 PM
I wouldn't do that, I would put the Vlookup formula in a helper cell, and
then test that helper cell for #N/A
--
---
HTH
Bob
(change the xxxx to gmail if mailing direct)
"Richard" <Richard@discussions.microsoft.com> wrote in message
news:CD024860-FF96-403E-874B-22230369D745@microsoft.com...
> Right. I have been frequently using your if statement in my worksheets.
> However, it is a long statement and I often have to retype/proof to get it
> correct.
>
> I was looking for a function that I could define in a macro.
> Combining the application.worksheetfunction format with ISNA and Vlookup
> commands in a macro was giving me problems.
>
>
> --
> Richard
>
>
> "Bob Phillips" wrote:
>
>> =IF(ISNA(vlookup_formula),"",vlookup_formula)
>>
>> --
>> ---
>> HTH
>>
>> Bob
>>
>> (change the xxxx to gmail if mailing direct)
>>
>>
>> "Richard" <Richard@discussions.microsoft.com> wrote in message
>> news:DD580267-24DE-4129-AF2E-F58995275646@microsoft.com...
>> >
>> > The normal vlookup function returns a NA if the table_array doesn't
>> > contain
>> > the lookup_value.
>> >
>> > Can you help me write a new function that returns a blank or ""
>> > instead?
>> >
>> >
>> > --
>> > Richard
>>
>>
>>