INDEXING

  • Thread starter Thread starter phuser
  • Start date Start date
P

phuser

I have a indexing statement to match up product codes but if there is no
number in the matched code it returns a 0, is it possible to use INDEX with
an ISERROR statement or Less than? I've tried many different ways to do it
and am unable to figure it out for myself.

=INDEX(Q3:Z3000,MATCH(+N7,Q3:Q3000,0),3)


Thanks for Reading
 
Could give an IF statement a try (not tested):
=if(INDEX(Q3:Z3000,MATCH(+N7,Q3:Q3000,0),3)=0,"Not
Found",=INDEX(Q3:Z3000,MATCH(+N7,Q3:Q3000,0),3))
 
You Da Best Thanks

This Worked :-D

=IF(INDEX(Q3:Z3000,MATCH(+N7,Q3:Q3000,0),3)=0,"",INDEX(Q3:Z3000,MATCH(+N7,Q3:Q3000,0),3))
 
Back
Top