I have the following function in excel: MATCH(B3,ETF!$F:$F, 0)
我在excel中有以下功能:MATCH(B3,ETF!$ F:$ F,0)
Which spits out the row number of a particular value B3 like 49930.
其中吐出特定值B3的行号,如49930。
In the cell below, I have the following:
在下面的单元格中,我有以下内容:
=MAX(ROW(49930:77721)*(ETF!A49930:G77721=B3))
This spits out the last occurrence of cell value B3 in another range.
这会在另一个范围内吐出最后一次出现的单元格值B3。
Instead of hardcoding 49930, is there a way for me to reference the value 49930, which is stored in B1?
而不是硬编码49930,有没有办法让我引用存储在B1中的值49930?
1 个解决方案
#1
0
Use the Indirect Formula. I allows you to create references. Something like this for example (untested):
使用间接公式。我允许你创建引用。例如这样的东西(未经测试):
=INDIRECT("F:"&MATCH(B3,ETF!$F:$F, 0);TRUE)
#1
0
Use the Indirect Formula. I allows you to create references. Something like this for example (untested):
使用间接公式。我允许你创建引用。例如这样的东西(未经测试):
=INDIRECT("F:"&MATCH(B3,ETF!$F:$F, 0);TRUE)