Return result when condition is met

[Gotroots]

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

 

[Glenn]

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(),"")

 

[Paul C]

you can nest your if statement like this

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

 

[Gotroots]

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

 

[Jacob Skaria]

If you mean both the conditions then try

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

 

[Gotroots]

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

Thank you all for contributing.