The really frustrating part is that if I step through the formula, it all seems to work almost perfectly. My structured references identify the correct range of cells. However, the MATCH element of the formula keeps returning an #N/A even though the values are there to be matched.

Does anyone know of any typical reason why this might occur?

Thanks in advance