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.a...tions/201003/1

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


--

HTH

Bob

"Mattlynn via OfficeKB.com" <u44078@uwe wrote in message
news:a4b544db98c65@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.a...tions/201003/1

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@uwe wrote in message
news:a4b544db98c65@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.a...tions/201003/1

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

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.a...tions/201003/1

.

"Mike H" wrote in message
...

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.

You're welcome. Thanks for the feedback.

Regards,
Fred

"Mattlynn via OfficeKB.com" <u44078@uwe wrote in message
news:a4b58e42e8f7c@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