add If to formula to blank #n/a

[Diddy]

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!

 

[Max]

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]

Thank you Max
--
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

 

[Max]

Welcome, Deirdre
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500, Files:358, Subscribers:55
xdemechanik