Index Match if result is not something

Hi,
Does anyone have any ideas on how to do the following:

When I uncheck a box on my form, I want the formula in a cell to search through a database and return a matching value, and if I check the box, I want it to return a pre-determined value. I have a macro that then adds this data to the database by inserting a row. The database is always updated with my latest entries.

Here's what I have so far:

Formula:

=IF(AND(M1=TRUE,ISTEXT(E10)),INDEX(Sheet1!$F$7:$F$605,MATCH(E10,Sheet1!$G$7:$G$605,0)),IF(AND(M1=FALSE,ISTEXT(E10)),"000",""))

The problem is, if I were to check the box and "000" were then entered into the database, then the next time I try to make an entry and I uncheck my box, then my INDEX MATCH formula will return "000", since it wants to find the first match in the list and "000" is on top, so I've lost my options. I need the formula to ignore any result that equals "000" and move on to the next occurence.

Any ideas?


Thanks.