Prev: Formula Help
Next: How do I filter data by more than one column in excel
From: Bob Phillips on 8 Mar 2010 13:36

"Mike H" <MikeH(a)discussions.microsoft.com> wrote in message
news:0534817D-ECE3-4678-B7D5-01087D833862(a)microsoft.com...
>
> BTW. Unless it's essential then avoid using full columns, it can slow
> things
> down a lot.

In an arry formula using too many rows can be a problem Mike, but in a
non-array function, I don't think so.


From: Fred Smith on 8 Mar 2010 15:37
You're welcome. Thanks for the feedback.

Regards,
Fred

"Mattlynn via OfficeKB.com" <u44078(a)uwe> wrote in message
news:a4b58e42e8f7c(a)uwe...
> thank you everyone - thats just what i needed - perfectomundo
>
> Matt
>
>
> Fred Smith wrote:
>>Do it this way:
>>=IF(ISNA(VLOOKUP(J5,A:B,2,FALSE)),"",VLOOKUP(J5,A:B,2,FALSE))
>>
>>Regards,
>>Fred
>>
>>> Hi
>>> Can someone please add an ISNA bit to this please for use into excel
>>> 2007.
>>[quoted text clipped - 3 lines]
>>>
>>> =VLOOKUP(J5,A:B,2,FALSE)
>
> --
> Matt Lynn
>
> Message posted via http://www.officekb.com
>

First  |  Prev  | 
Pages: 1 2
Prev: Formula Help
Next: How do I filter data by more than one column in excel