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.