Hi everyone,

I'm using the following formula

=INDEX(Stats!$K$2:$K$47,MATCH($B3,Stats!$G$2:$G$47,0))

How do I add to this to not have #N/A when it doesn't find a match?

Thank you!
--
Deirdre

Just add an IF(ISNA(..) error trap on the MATCH part of it, eg
=IF(ISNA(MATCH($B3,Stats!$G$2:$G$47,0)),"",INDEX(Stats!$K$2:$K$47,MATCH($B3,Stats!$G$2:$G$47,0)))

Adapt the return: "" to suit what you want for unmatched cases
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500 Files:358 Subscribers:55
xdemechanik
---
"Diddy" wrote:
> Hi everyone,
>
> I'm using the following formula
>
> =INDEX(Stats!$K$2:$K$47,MATCH($B3,Stats!$G$2:$G$47,0))
>
> How do I add to this to not have #N/A when it doesn't find a match?
>
> Thank you!
> --
> Deirdre

Thank you Max :-)
--
Deirdre


"Max" wrote:

> Just add an IF(ISNA(..) error trap on the MATCH part of it, eg:
> =IF(ISNA(MATCH($B3,Stats!$G$2:$G$47,0)),"",INDEX(Stats!$K$2:$K$47,MATCH($B3,Stats!$G$2:$G$47,0)))
>
> Adapt the return: "" to suit what you want for unmatched cases
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> Downloads:17,500 Files:358 Subscribers:55
> xdemechanik
> ---
> "Diddy" wrote:
> > Hi everyone,
> >
> > I'm using the following formula
> >
> > =INDEX(Stats!$K$2:$K$47,MATCH($B3,Stats!$G$2:$G$47,0))
> >
> > How do I add to this to not have #N/A when it doesn't find a match?
> >
> > Thank you!
> > --
> > Deirdre

Welcome, Deirdre
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500, Files:358, Subscribers:55
xdemechanik
---
"Diddy" <(E-Mail Removed)> wrote in message
news:38F24B98-81D4-4A8C-9D6B-(E-Mail Removed)...
> Thank you Max :-)
> --
> Deirdre