Making part of a statement iterative in Excel

I have a lookup that works for a single column:

=IFERROR(INDEX($C$2:$C$145,MATCH(A2,$D$2:$D$145,0)),"")

If A2 matches the range of values in D2 to D145, then output the corresponding C2 to C145 value in cell B2

This populates column B2 successfully.

How could I put that into a loop, so that the $D$2:$D$145 part iterates between column D and column GS? ($D$2:$D$145, $E$2:$E$145, $F$2:$F$145 etc)

Really appreciate any hints from anyone at this point.