Thursday, July 31, 2014

yogi_From Table of Times Course Names And Attendees Pull Times And Course Names For Specified Attendee

                           Google Spreadsheet   Post  #1717
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul-31-2014
post by J. Bennett (HCC):
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/LJC1roCsIuM)
HLOOKUP "in reverse"
I'm looking for a function (or possible build a formula) that will find a particular value in an array, and return the value at the top of the array in the same column. I have a signup sheet for one of three workshops offered at a particular time. The top row is the title of each workshop, and users are filling in there names in each column. I would like to automate the creation of agendas for each person by having the formula find each users name, and then returning the title of the workshop at the top of that column.


All e-mail correspondence to and from this address is subject to the North Carolina Public Records Law as defined under N.C.G.S. §132.1, which may result in monitoring and disclosure to third parties, including law enforcement and the media.

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