Problem: Sheet 1 should return concatenated values to a certain index that is also hold in sheet 1. Sheet 2 should be searched for this value.
In my case: Sheet 1 holds a string (e.g. "Demos - Sales Gespräche mit Leads") in column B. Now I would like to look for this value in a matrix in Sheet 2 and give back all column headers of the columns that hold this value ("Demos - Sales Gespräche mit Leads"). In my example there would be a couple of names of the person who is assigned to the certain job.
Here is an example sheet: https://docs.google.com/spreadsheets/d/1Q3CrdNbWyVwUAnODwBA7G05FSPLThBHHlWMItt6PNDc/edit?usp=sharing
Possible solution: Some combination of concatenate, vlookup, index and hlookup. I just can't think of how to do this.
Thanks
Aucun commentaire:
Enregistrer un commentaire