Re: VLOOKUP AND #N/A
- From: "RagDyer" <ragdyer@xxxxxxxxxxxxx>
- Date: Mon, 9 Jun 2008 12:43:55 -0700
Try this:
=IF(ISNA(MATCH(A6,H7:H121,0)),"",VLOOKUP(A6,H7:M121,3,0))
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Mike Saffer" <MikeSaffer@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CA578831-5AA9-44AF-8F26-FCBF63F332A2@xxxxxxxxxxxxxxxx
Greetings everybody,
I tried 3 other answers given in the archives first but still haven't been
able to sucessfully make this one work with VLOOKUP.
My formula in B6:
=IF(ISERROR(VLOOKUP(A6,H7:M121,3)),"",VLOOKUP(A6,H7:M121,3,FALSE))
I'm looking for for an exact match to A6 in column H of my VLOOKUP table
H7:M121 and return the value in the 3rd column, in this case column J.
Here's the kicker. I deliberately excluded what I was looking for in A6,
from cloumn H, trying to force an error of #N/A or #VALUE. Well, in this
case I got the #N/A error. error. I also tried =if(ISERROR(....... but
no
joy. The error is still visable.
I was hoping to get a blank in B6 when there is an error, instead of a
zero,
or #N/A, or #VALUE.
As always I appreciate any help.
Thanks,
Mike
Jacksonville, Florida
.
- Prev by Date: Re: VLOOKUP AND #N/A
- Next by Date: Re: TABLE function?
- Previous by thread: Re: VLOOKUP AND #N/A
- Next by thread: Re: VLOOKUP AND #N/A
- Index(es):
Relevant Pages
|
