Extract list from range Google Sheets


I have some data from workplaces with some different work areas, I need to extract a list for each workplace with their corresponding availables working areas, I have an example of some kind of attempt really close what I wanted. I use this formula but with more data will be long time to do it =IF(D2=$G$1, "Yes", "No"). I want to do it more automatic with some formulas but I don’t know where to start.

enter image description here


Give a try on below formula. Put the formula to G1 cell then drag down as needed.


enter image description here

Answered By – Harun24hr

Answer Checked By – Gilberto Lyons (AngularFixing Admin)

Leave a Reply

Your email address will not be published.