间接使用不同单元格中的列引用和行引用-INDIRECTwithcolumnreferenceandrowreferenceindifferentcells

So I have two cells, both referring to another sheet. One cell has the row of the other sheet and another has the column.

所以我有两个单元格,都指的是另一个单元格。一个单元格具有另一个单元格的行,另一个单元格具有该列。

I tried using an indirect statement along the lines of this: =INDIRECT("'VENDOR COSTING'!R"&R2&"C"&S2) Although I did do a ConvertToLetter so the column letter is F and it is currently in Cell U2. Vendor costing is the other sheet name and the row number is in cell R2.

我尝试使用间接语句:= INDIRECT(“'VENDOR COSTING'!R”和R2&“C”和S2)虽然我确实做了ConvertToLetter,所以列字母是F,它目前在Cell U2中。供应商成本核算是另一个工作表名称,行号在单元格R2中。

How can I write an indirect statement to produce the value in that cell on the other sheet?

如何编写间接语句以在另一个工作表中生成该单元格中的值?

1 个解决方案

=INDIRECT("'VENDOR COSTING'!"&U2&R2)