Copy Formula Horizontally, Incrementing Row

[waxsublime]

I'm trying to figure out how to automatically increment the row reference in a formula copied horizontally.

Example:

='Example Tab'!$A2	='Example Tab'!$A3	='Example Tab'!$A4

<tbody>
</tbody>

...and so on across several columns.

How can I do that?

Thanks in advance!

 

[markmzz]

Try this small modification:

=((ISNUMBER(FIND(INDIRECT("'Mapping'!$B"&COLUMNS($R:T)),$D2))+
ISNUMBER(FIND(INDIRECT("'Mapping'!$D"&COLUMNS($R:T)),$F2)))*
($E2=INDIRECT("'Mapping'!$E"&COLUMNS($R:T))))+($M2=INDIRECT("'Mapping'!$A"&COLUMNS($R:T)))

Markmzz

 

[markmzz]

Try this small modification:

=((ISNUMBER(FIND(INDIRECT("'Mapping'!$B"&COLUMNS($R:T)),$D2))+
ISNUMBER(FIND(INDIRECT("'Mapping'!$D"&COLUMNS($R:T)),$F2)))*
($E2=INDIRECT("'Mapping'!$E"&COLUMNS($R:T))))+($M2=INDIRECT("'Mapping'!$A"&COLUMNS($R:T)))

Markmzz

Sorry, but the formula above isn't ok.

Markmzz

 

[waxsublime]

Genius!!! That worked perfectly! Thanks so much for this!

 

[waxsublime]

The first one you posted worked great.

"Mapping" Tab Data starts at A2.

This formula is in R2:

=IF(OR((AND(OR(ISNUMBER(FIND(INDIRECT("'Mapping'!$B"&COLUMNS($R:S)),$D2)),
ISNUMBER(FIND(INDIRECT("'Mapping'!$D"&COLUMNS($R:S)),$F2))),$E2=INDIRECT("'Mapping'!$E"&COLUMNS($R:S)))),
$M2=INDIRECT("'Mapping'!$A"&COLUMNS($R:S))),1,)

When I copied to columns S, T, and U, it changed the formula perfectly. Thanks so much for this, again!

 

[markmzz]

Waxsublime,

I'm happy that your problem was solved.

And thanks for the feedback.

Markmzz

 

[markmzz]

Hi Waxsublime,

If possible, do some tests with this small modification and tell me if it work.

R2-> =IF(((
ISNUMBER(FIND(INDEX(Mapping!$B:$B,COLUMNS($R:S)),$D2))+
ISNUMBER(FIND(INDEX(Mapping!$D:$D,COLUMNS($R:S)),$F2)))*
($E2=INDEX(Mapping!$E:$E,COLUMNS($R:S))))+
($M2=INDEX(Mapping!$A:$A,COLUMNS($R:S))),1,)

Markmzz