Google Spreadsheet Post #2481
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI Jul-26-2018
question by: Steven Goovaerts
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/jI1bs1T3skI;context-place=forum/docs
Please Help - Return cell data based on range search
Hi!
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!
SHARED SHEET HERE:
https://docs.google.com/
No comments:
Post a Comment