Pass Variable in IF Formula

[rizmomin]

Hello:

Please refer to attached sheet.

I need to create IF Formula in column C ( C4:C34)

The format is shown in cell C4 and C5.
FYI : You may use referance in column B for formula.

Please let me know if any questions.

Thank you

Riz Momin

[Fotis1991]

Not clear what is your goal riz. Perhaps..

Please Login or Register  to view this content.

[rizmomin]

Hi Fotis1991:

Hello:

Please refer to attached sheet.

Basically below is what I am trying to achieve.

In Cell B4:B34, there is column#.
I need to check in each of these column in row 4 to see if any character exit.
IF any character exist then put "YES" in corresponding cell in column C.
If no character exist then put "NO" in corresponding cell in column C.

So need =IF statement

For example:

Cell B4 = E, so need to check cell E4 and if E4 is blank then put "NO" in cell C4
Cell B5 = I, so need to check cell I4 and if I4 is blank then put "NO" in cell C5
Cell B6 = M, so need to check cell M4 and if M4 is blank then put "NO" in cell C6


Please let me know if any questions.

Thank you

Riz Momin

[XOR LX]

Hi,

This is why Jonmo asked you if the result of your previous thread was to be used in a further formula: here, you don't need to reference the 'letters' in column B, and no INDIRECTs either. Simply, in C4 and copy down:

=IF(INDEX($4:$4,,4*(ROWS($1:1)-1)+5)="","NO","YES")

Regards

[rizmomin]

Hi XOR LX:

Oh I see your comment and once again thank you so much for helping.
This will work great for me.

Thank you

Riz Momin

[XOR LX]

You're welcome.