I usually find an answer online but this one has me stumped. Here is the sheet:

http://www.hvlistings.com/NASCAR2010.XLS

I plan to enter races on the Races sheet. Each race takes up 2 columns (Driver and Points for that race). I then want to use INDEX and MATCH to get the points onto the TEAMS page. If you look at Row 7 of the TEAMS page, it works OK until I get to Race 14. This is because the columns are now AA, AB, etc and the CHAR function does not work. Is there a better, cleaner way to do this? I put scores for Jimmy Johnson all the way through the 36 races (each score corresponds with the race #), so it is easy to test a fix.

Thanks in advance!