Prev: Formula Help
Next: How do I filter data by more than one column in excel
From: Mattlynn via OfficeKB.com on 8 Mar 2010 11:12
Hi
Can someone please add an ISNA bit to this please for use into excel 2007.
I have been trying for ages and have been getting all tied up with it
Many Thanks
Matt



=VLOOKUP(J5,A:B,2,FALSE)

--
Matt Lynn

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/excel-functions/201003/1

From: Bob Phillips on 8 Mar 2010 11:21
=IFERROR(VLOOKUP(J5,A:B,2,FALSE),"")


--

HTH

Bob

"Mattlynn via OfficeKB.com" <u44078(a)uwe> wrote in message
news:a4b544db98c65(a)uwe...
> Hi
> Can someone please add an ISNA bit to this please for use into excel 2007.
> I have been trying for ages and have been getting all tied up with it
> Many Thanks
> Matt
>
>
>
> =VLOOKUP(J5,A:B,2,FALSE)
>
> --
> Matt Lynn
>
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.aspx/excel-functions/201003/1
>


From: Fred Smith on 8 Mar 2010 11:28
Do it this way:
=IF(ISNA(VLOOKUP(J5,A:B,2,FALSE)),"",VLOOKUP(J5,A:B,2,FALSE))

Regards,
Fred


"Mattlynn via OfficeKB.com" <u44078(a)uwe> wrote in message
news:a4b544db98c65(a)uwe...
> Hi
> Can someone please add an ISNA bit to this please for use into excel 2007.
> I have been trying for ages and have been getting all tied up with it
> Many Thanks
> Matt
>
>
>
> =VLOOKUP(J5,A:B,2,FALSE)
>
> --
> Matt Lynn
>
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.aspx/excel-functions/201003/1
>

From: Mattlynn via OfficeKB.com on 8 Mar 2010 11:45
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

From: Mike H on 8 Mar 2010 12:02
Mat,

I prefer this method

=IF(COUNTIF(A:A,J5)>0,VLOOKUP(J5,A:B,2,FALSE),"")

but if you want isna

=IF(ISNA(VLOOKUP(J5,A:B,2,FALSE)),"",VLOOKUP(J5,A:B,2,FALSE))

BTW. Unless it's essential then avoid using full columns, it can slow things
down a lot.


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Mattlynn via OfficeKB.com" wrote:

> Hi
> Can someone please add an ISNA bit to this please for use into excel 2007.
> I have been trying for ages and have been getting all tied up with it
> Many Thanks
> Matt
>
>
>
> =VLOOKUP(J5,A:B,2,FALSE)
>
> --
> Matt Lynn
>
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.aspx/excel-functions/201003/1
>
> .
>
 |  Next  |  Last
Pages: 1 2
Prev: Formula Help
Next: How do I filter data by more than one column in excel