Saturday, May 31, 2014

yogi_From A Table Of Products By Name Create A Table Of Names By Product


                                         Google Spreadsheet   Post  #1655
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May-31-2014
post by Sargon Aldent: (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/Hk8kNPU_PV8)
I am trying to create several lists of names that are based on abilities from a table. The table is in rows like this:
A                 B                  C                   D                   E
1  Lisa        COOKS      CLEANS      DRIVES          SEWS
2 Linda       COOKS      CLEANS          na                   na

For example:

Lisa    Cooks, Cleans, Drives, and Sews.
David Cooks, cleans
Linda Drives
Sue Cooks and Sews


Cooks List:
Lisa
David
Sue

Cleans list
Lisa
David
Sue

Drives list
Lisa
Linda



Tried using Hlookup but the value returned is text and always get an error because Hlookup expects the result to be  a number. Does anyone have a simple solution or function I can use to do this??

Thanks

---
Hi, 
https://docs.google.com/spreadsheets/d/1arfY8JNggWMLu5w0UowDJqzgRLJutQlmAJHsaYzXvSs/edit?usp=sharing

This is a example of what I was trying to do, but without the errors in the list.

Thanks,

-----------------------------------------------------------------------------------------------------------------------------------------------