excel-2.jpg
excel-help-needed.xlsx

This file has got few cells which are showing "NO", I want to search this grid i.e P1 to AD23, check that where are the "no" cells located and than in cells R31 and S31, want the corresponding values of each "no" cell.

For e.g:

For P4 the value is "no" so in R31 I need 1478 and in S31 I need 1912, that are two values of "no" in P4.

Similarly for next "no" i.e Q3, I need values in next row R32=1478 and S32=2285

it should continue in rows for each "no", in this file, there are 11 cells with "no" so there should be 11 rows showing 2 corresponding values of each "no".

Many Thanks.