Hi there,

I'd like some help on another alternative to this:

=IF(AZ9<=2000,LOOKUP(BB9,AG3:AG24,AF3:AF24),IF(AZ9<=2005,LOOKUP(BB9,AI3:AI24,AH3:AH24)))

Cell AZ9 can vary from 2000 to 10000

How can I do this is in increments of 5 without trying to nest 1600 IF functions?

Many thanks,