How to extract and populate data based on two matching cells
I am trying extract data based on matching 2 cells. Can anyone help me with the formula?
For Example: If data in C1 = B3 then
b4 c4 b5 c5 b6 c6 ...
One Solution collect form web for “How to extract and populate data based on two matching cells”
Without knowing what values you want in the populated cells I’m not sure how to answer… however the basic formula is above…
and example image below: