英文:
If name exists in a table then return value from another column or row
问题
我想要在附表中找到每个人对应的标题和位置。基本上，我想要在绿色单元格中使用公式，以提取列E中每个名字右侧的相应位置号码和行A中的酒吧名。有什么最佳的方法吗？例如，Gab 对应 Bar 2 和位置 2，Nick 对应 Bar 4 位置 3，等等。
英文:
I want to find the corresponding header and position for each person in the attached table. Basically I would like a formula in the green cells to pull the corresponding position number to the right of each name in column E and the bar name in row A. What is the best way to do that? For example, Gab would be Bar 2 and position 2, Nick would be Bar 4 position 3, etc.
Thanks!
https://docs.google.com/spreadsheets/d/1JXYXkN8ovwcJvVWN5-kHb0-N8sFIbVIP5qwesUPLCQw/edit?usp=sharing
答案1
得分: 2
Bar
=tocol(index(if(A2:D7=A12,A1:D1,)),1)
Position
=tocol(index(if(A2:D7=A12,E2:E7,)),1)
英文:
You may try:
Bar
=tocol(index(if(A2:D7=A12,A1:D1,)),1)
Position
=tocol(index(if(A2:D7=A12,E2:E7,)),1)
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论