Index Match with Offset

[Bravo2003]

Not sure if this is the way to work this for a good solution:
I have the following formula in each cell
CW57 - =INDEX(E$4:E$21,MATCH($A53,$A$4:$A$21,0))
CX57 - =INDEX(N$4:N$21,MATCH($A53,$A$4:$A$21,0))
CY57 - =INDEX(W$4:W$21,MATCH($A53,$A$4:$A$21,0))

Etc.. I need a quicker way to get the results from the columns as I add more data, so as you see E column to N column (is 9 columns and so on each column result needed is 9 columns along)
so I don't need to manually change the column for result letter each time I drag the formula across 1 cell?

Would OFFSET work in to this folrmula?

If it helps, the results looked up for are all values (e.g. £585.56)

 

[Fluff]

How about

=INDEX($E$4:$BZ$21,MATCH($A53,$A$4:$A$21,0),COLUMNS($CW:CW)*9-8)

 

[Bravo2003]

How about

=INDEX($E$4:$BZ$21,MATCH($A53,$A$4:$A$21,0),COLUMNS($CW:CW)*9-8)

Thank you, it works perfect. Not sure how or what it's doing, but I will look in to using this in a few more options it can replace in my spreadsheet that has similar set ups.

Going to be a great help. Thanks

 

[Fluff]

You're welcome & thanks for the feedback.