I'm trying to create an easy way to reveal more data from a row when any
cell is clicked from the row it lives in. Currently, I have a nice
=VLOOKUP("*")
... function that allows me to type in a COMPANY name into a "search bar"
cell, and then VLOOKUP will display cell contents depending on which COMPANY it
is.
*You can see it in action here:* Google Sheets Demo
<https://docs.google.com/spreadsheets/d/1a1sk86VVTpQMHgqSK4iiGeIZIXPyfpnI3GMqzHQSxR4/edit?usp=sharing>
How To Use:
*Green Cells:* Type in the "Search Bar" cell for a company name...
*Orange Cells:* If "COMPANY" is found, it displays the companies cell
contents to the left.
What I want to do:
1. Click on a cell in any row
2. Have that cell realize what row it's in and navigate to the COMPANY
column.
3. Copy the cells contents from the COMPANY column and replace the
current contents of the "search bar" cell
4. VLOOKUP will then handle the rest.
1.
------------------------------
Possible?
Is this possible with Google Sheet functions alone? Or is this something
that should be handled with a script? How would I got about it?
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
