Thursday, July 26, 2018

yogi_Find Associated District From Given Set of Road/Locality and District Data

Google Spreadsheet   Post  #2481

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Jul-26-2018

question by: Steven Goovaerts!topic/docs/jI1bs1T3skI;context-place=forum/docs

Please Help - Return cell data based on range search


I am very new to this and was hoping someone may be able to help?

I have been trying and failing to come up with a way to search a cell value across a large data set and return the column title of the located cell as the result.

I have tried everything from VLOOKUP/HLOOKUP to INDEX and MATCH, to ARRAYS, but I am completely lost.

I have attached a sheet with an example data set.  It includes a table of district groups and individual road references within those districts.

Essentially, I would like to be able to search by a road reference in a cell (e.g. "ElBrto2") and have the results return the district it is in (e.g. Springfield).  Something like ... SEARCH RANGE FOR ... "ElBrto2" AND RETURN RELEVANT COLUMN HEADER.

I am sure there is a simple way around this, so apologies for asking something so basic.

Any help would be greatly appreciated :)  Thanks!