Solution for following problem:

Suggest a formula for the below problem:


Consider Sheet 2 of the attached file:

As you can see two cells i.e. H17 & I17 are highlighted.

When two cells of the same row are highlighted, i.e. H17 & I17, then the corresponding cell of same row “17” of Column “G” should be displayed in B15 cell.



By: Arya

Leave a Reply

Your email address will not be published. Required fields are marked *