The 'Age' in A5 is a date, not an actual number, it won't match that in the range, so it takes the next highest.
1. Change the format for cell A5 to 'general' then change the number to 32
2. Change your formula to this:Hope that helps!Formula:![]()
=INDEX(Age_Table,MATCH(A5,Age_Table_Ages,1)+1,MATCH("Cost",Age_Table_Headings,0))
-Moo
Bookmarks