Return result when condition is met
 

The following formula returns the row number

=IF(INDIRECT("A"&ROW(IV4))="","",ROW())

I want it now to only return a result if "D" contains the value "No record"

Thank you

Return result when condition is met
 

Gotroots wrote:
The following formula returns the row number

=IF(INDIRECT("A"&ROW(IV4))="","",ROW())

I want it now to only return a result if "D" contains the value "No record"

Thank you


Do you mean this:


=IF(INDIRECT("D"&ROW(IV4))="No record",ROW(),"")

Return result when condition is met
 

you can nest your if statement like this

=IF(INDIRECT("A"&ROW(IV4))="","",IF(INDIRECT("A"&R OW(IV4))="D",ROW(),""))
--
If this helps, please remember to click yes.


"Gotroots" wrote:

The following formula returns the row number

=IF(INDIRECT("A"&ROW(IV4))="","",ROW())

I want it now to only return a result if "D" contains the value "No record"

Thank you

Return result when condition is met
 

Hello guys,

Sorry, but neither solutions worked.
Perhaps it's to do with the fact that the values in "D" are the result of a
relative formula

"Glenn" wrote:

Gotroots wrote:
The following formula returns the row number

=IF(INDIRECT("A"&ROW(IV4))="","",ROW())

I want it now to only return a result if "D" contains the value "No record"

Thank you


Do you mean this:


=IF(INDIRECT("D"&ROW(IV4))="No record",ROW(),"")
.

Return result when condition is met
 

If you mean both the conditions then try

=IF(AND(INDIRECT("A"&ROW(IV4))="",INDIRECT("D"&ROW (IV4))="No
record"),"",ROW())

--
Jacob


"Gotroots" wrote:

Hello guys,

Sorry, but neither solutions worked.
Perhaps it's to do with the fact that the values in "D" are the result of a
relative formula

"Glenn" wrote:

Gotroots wrote:
The following formula returns the row number

=IF(INDIRECT("A"&ROW(IV4))="","",ROW())

I want it now to only return a result if "D" contains the value "No record"

Thank you


Do you mean this:


=IF(INDIRECT("D"&ROW(IV4))="No record",ROW(),"")
.

Return result when condition is met
 

Actually, Glenn's solution was successful after all, typo error on my part.

Thank you all for contributing.

"Jacob Skaria" wrote:

If you mean both the conditions then try

=IF(AND(INDIRECT("A"&ROW(IV4))="",INDIRECT("D"&ROW (IV4))="No
record"),"",ROW())

--
Jacob


"Gotroots" wrote:

Hello guys,

Sorry, but neither solutions worked.
Perhaps it's to do with the fact that the values in "D" are the result of a
relative formula

"Glenn" wrote:

Gotroots wrote:
The following formula returns the row number

=IF(INDIRECT("A"&ROW(IV4))="","",ROW())

I want it now to only return a result if "D" contains the value "No record"

Thank you


Do you mean this:


=IF(INDIRECT("D"&ROW(IV4))="No record",ROW(),"")
.