QueenOfCoach:

Thanks for the feedback!

Yes I think you have the right idea with the booking class lookup tables. When I get some free time I will probably set them up for AA and AS, as you and VNAFlyer suggested.

The reason I have duplicate data in the airline and flight number fields is because I frequently fly AA/AS codeshare flights--currently the way I'm doing it is to have the issuing airline in the "flight" column and the operating airline in the "airline" column. This is probably not really strictly necessary, and I would have to change that convention if I used lookup tables for EQP calculation anyway.

Yes, past flight date highlighting is done with conditional formatting!