英文:
How to fix returning of the first value in a column instead of the appropriate value using VLOOKUP in Google Sheets?
问题
Here is the translation of the code-related part:
在这个屏幕上，"C9" 是一个下拉列表的 "A" 值。 "D9" 是 "VLOOKUP" 函数的结果。在 "E9" 中，我需要获取列 "B" 中值 "D9" 的索引。但问题是它总是返回列中的第一个值。如屏幕截图所示，它应该返回 "B6"。
这个问题有解决的方法吗？谢谢。
我尝试了这段代码：
=ADDRESS(MATCH(VLOOKUP(C9;A2:B6;2;FALSE);B1:B6;0);2;4)
英文:
Good afternoon Please give advice.
In this screen, "C9" is a drop-down list of "A" values. "D9" is the result of the "VLOOKUP" function. In "E9" I need the index of the value "D9" from column "B". But the problem is that it always returns the first value in the column. As on a screenshot it should return "B6".
Is the a way of solving this problem? Thank you.
I tried this code:
=ADDRESS(MATCH(VLOOKUP(C9;A2:B6;2;FALSE);B1:B6;0);2;4)
答案1
得分: 0
"你可以尝试：\n\n ="B"&xmatch(C9,A:A)"
英文:
You may try:
="B"&xmatch(C9,A:A)
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论