maybe something like this

=N$4*VLOOKUP($B5,$A$2:$AJ$500,INDIRECT(CHAR(95+COLUMN()+1)&"3"),FALSE) -> fill sideways