Sunday, August 7, 2011

yogi_Unique Lookup Values Based on Multiple Criteria


Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

Taz002 said:
Unique VLookup values based on multiple criteria
I am trying to somehow combine the UNIQUE() formula with a VLOOKUP() without any luck so far. I want to have it so if I change the name in a cell it will return a list that is automatically generated based on the name with each given unique data in column 2. Here is an example spreadsheet, any help appreciated.
---------------------------------------------------------
I have updated the following solution based on updating of the specification by Taz002