dukeofscouts
Board Regular
- Joined
- Jan 19, 2009
- Messages
- 146
I've got a series of formulas in my cell that goes down my data, evaluates it to a list of Trues and Falses and then returns a value. Part of this is a MATCH formula that looks at an INDEX function which is returning 1 row from my data set. Most of the time this formula works PERFECTLY. However, every once in a while it is throwing me an "#n/a" error message. If I go in and watch it using "ALT + T + U + F" the error is on this match statement. HOWEVER, if I go in and in edit mode try and mimic "ALT + T + U + F" by using "F9", the match evaluates perfectly...
Any one ever hear of this kind of thing?
Basic set up:
MATCH(extracted_value_from_data_set,extracted_row_of_data_set,0)
Any one ever hear of this kind of thing?
Basic set up:
MATCH(extracted_value_from_data_set,extracted_row_of_data_set,0)