INDEXING

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

phuser - 06 Sep 2007 20:39 GMT

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

Reply to this Message

JW - 06 Sep 2007 21:06 GMT

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))

> 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
[quoted text clipped - 4 lines]
>
> Thanks for Reading

Reply to this Message

phuser - 06 Sep 2007 21:20 GMT

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))

> Could give an IF statement a try (not tested):
> =if(INDEX(Q3:Z3000,MATCH(+N7,Q3:Q3000,0),3)=0,"Not
[quoted text clipped - 10 lines]
>>
>> Thanks for Reading

Reply to this Message