Forum Discussion
Broken Index/Match formula
Chuck,
your filters in K10:P10 don't match any records in B4:G3109.
If you think there should be a match check the spelling and look for trailing spaces.
Could you elaborate as to why this would work for other drop down categories, but not one specific one? It's the same formula but based on the data list and the item chosen off those lists it generates a labor hours return. I've attached screen shots of the table working, not working, and data index.
- There is much more “broken “....and about to become “unmatched “ than some folks will let themselves believe!!! Something has to give!! It’s way past due,don’t ya think?!?!😢
They are saying that
=MATCH("ABC", {"ABC "}, 0)will give out #N/A.
"Could you elaborate as to why this would work for other drop down categories, but not one specific one? "
I just guess that it is "Quarterly " at the row you highlighted in the data index sheet. Matching "Triannual" correctly doesn't mean that other data is correctly spelled in data index sheet.
If you study what yourself had just said "It's the same formula but based on the data list and the item chosen off those lists it generates a labor hours return." you can know what is happening.
I agree with Detlef - check that row in your Data Index sheet, and check for any blank spaces that might sit in one of those six columns that you're looking up. Chances are, there's a rogue blank space that is causing the match to fail.
If the blank space was in the input sheet, then it's likely other combinations would fail too. My guess is that it's in the data, and you can narrow it down to that specific row (or any given row that's failing).
Edit: Another way you can check this - in a single line, just do a simple "=I4=Index!B726" (I think I've got the cell references right from your screenshots) and copy it to the right to check the other columns. The one that's coming up as FALSE is the one that you'll need to fix somewhere.
