I have used the match() function many times. I am using a simple match function but why it is returning an error has me puzzled. I have added an image of the spreadsheet here.
1. Column L is formatted as a number with 2 decimals.
2. My table array is in Column AI Rows 1352 - 1366. This is also formatted as a number with 2 decimal places.
3. Above my table array in rows 1341-1346 is the formula returning the N/a in all but 1 cell.
4. The formula I am using is =MATCH(L1346,$AI$1352:$AI$1366,0). For clarity L1346 is moving with each cell I copy.
5. Each of the values I am looking for exist so I am using the (0-Exact Match) option in the match.
6. I have tested each of the cells for blanks etc using the Len() function and all appears fine.
This should be a relatively simple formula, I am using it in a more complex Index,Match function but have only shown the match problem here as that is the element of the formula that is causing problems.
I would appreacte any steer I can get on this one, it has me stumped!
JohnH
1. Column L is formatted as a number with 2 decimals.
2. My table array is in Column AI Rows 1352 - 1366. This is also formatted as a number with 2 decimal places.
3. Above my table array in rows 1341-1346 is the formula returning the N/a in all but 1 cell.
4. The formula I am using is =MATCH(L1346,$AI$1352:$AI$1366,0). For clarity L1346 is moving with each cell I copy.
5. Each of the values I am looking for exist so I am using the (0-Exact Match) option in the match.
6. I have tested each of the cells for blanks etc using the Len() function and all appears fine.
This should be a relatively simple formula, I am using it in a more complex Index,Match function but have only shown the match problem here as that is the element of the formula that is causing problems.
I would appreacte any steer I can get on this one, it has me stumped!
JohnH