yogi_Pull Unique Names From B8:B Where Color Specified in J8 Matches That In Range C8:H

Google Spreadsheet   Post  #2086

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov-26-2016

question by: Ekim Otucu:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/ROQA-rvzxZI;context-place=forum/docs
Return name from column based on match in range of data?
I have a range of data, with the corresponding names to the left in a column. I want to have an example of data, and pull the corresponding names from the left out no matter where in the data the match to my example was found. Here is an example:

https://docs.google.com/spreadsheets/d/1bObxnrHa8GYqWiyAe25FObAGsxBhidl7bBf1Tuq9Azc/edit?usp=sharing

Thanks!

Ekim