IF and LOOKUP with multiple nested IF functions

Originally Posted by ragulduy

Well in the formula I posted, I use

ROUND(0.4*AZ9-800.8-0.4*MOD(AZ9,5)+0.8,0)

to return how many columns to move across from AG as a reference, so that bit of the formula will return 0 for 2000-2004, 2 for 2005-2009, 4 for 2010-2014 etc.

If you already have the headings however, you can replace that bit of the formula with a match function to return the offset for the column.

Thank you. both work nicely.