Formula tweak

[NotaVBAeXpert]

Currently, I have the following formula which is working perfectly...

=INDEX('Sheet2'!A:CG,MATCH($A$89,'Sheet2!$C:$C,0),MATCH('Sheet1 '!$G$89,'Std Values'!1:1,0)


Now the only problem, is if the output from this above formula returns zero, I would need the next value in that particular row.

Does it make sense to add a wildcard to the end of the formula such as :

=INDEX('Sheet2'!A:CG,MATCH($A$89,'Sheet2'!$C:$C,0),MATCH('Sheet1'!$G$89,'Sheet2'!1:1,0)*(MATCH($G$89,'Sheet2'!$C$1:$CG$1,0)))

Any help would be greatly appreciated.

 

[Chrisdontm]

Are you saying that you actually would want the next column over to the right if the answer is zero?

Instead of multiplying the column number of the INDEX formula, wouldn't you want to "add a one" to that column answer?

 

[Peter_SSs]

Duplicate to https://www.mrexcel.com/forum/excel-questions/1054396-finding-1st-value-row-if-prior-cells-row-blank.html

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per #12 of the Forum Rules and points 6 & 7 of the Forum Use Guidelines.

Any bumps, clarifications, or follow-ups should be posted to the linked thread.