<div>
HI, 
 
pls try ( adjust H2 and H$2) 
 

<pre><code id="code-20-41716342-1">=INDEX(OFFSET(Data!$G$4:$AE$4,3*(ROW(H2)-ROW(H$2)),0),MATCH(Sheet2!I$3,OFFSET(Data!$G$3:$AE$3,3*(ROW(H2)-ROW(H$2)),0),0))</code></pre>
Regards
</div>

HI,

pls try ( adjust H2 and H$2)



=INDEX(OFFSET(Data!$G$4:$AE$4,3*(ROW(H2)-ROW(H$2)),0),MATCH(Sheet2!I$3,OFFSET(Data!$G$3:$AE$3,3*(ROW(H2)-ROW(H$2)),0),0))

Regards

<div>
<div class="content wysiwyg-content">
Hello, 
 
I have the following formula: 
=INDEX('Data'!$G4:$AE4,MATCH(Sheet2!I$3,'Data'!$G3:$AE3,0)) 
 
I would like to fill this formula down but have both the ranges: 
'Data'!$G4:$AE4 
'Data'!$G3:$AE3 
 
E.g 
 
=INDEX('Data'!$G4:$AE4,MATCH(Sheet2!I$3,'Data'!$G3:$AE3,0)) 
=INDEX('Data'!$G7:$AE7,MATCH(Sheet2!I$3,'Data'!$G6:$AE6,0)) 
=INDEX('Data'!$G10:$AE10,MATCH(Sheet2!I$3,'Data'!$G9:$AE9,0)) 
 
increase in increments of 3 as I fill down. Is this possible?
</div>
</div>

Hello,

I have the following formula:
=INDEX('Data'!$G4:$AE4,MATCH(Sheet2!I$3,'Data'!$G3:$AE3,0))

I would like to fill this formula down but have both the ranges:
'Data'!$G4:$AE4
'Data'!$G3:$AE3

E.g

=INDEX('Data'!$G4:$AE4,MATCH(Sheet2!I$3,'Data'!$G3:$AE3,0))
=INDEX('Data'!$G7:$AE7,MATCH(Sheet2!I$3,'Data'!$G6:$AE6,0))
=INDEX('Data'!$G10:$AE10,MATCH(Sheet2!I$3,'Data'!$G9:$AE9,0))

increase in increments of 3 as I fill down. Is this possible?

Excel: Index/Match change range on fill down

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.