INDIRECT with column reference and row reference in different cells
excel, excel-formula, excel-indirect, worksheet-function
Solution
Please try:
=INDIRECT("'VENDOR COSTING'!"&U2&R2)
where U2 contains your Column reference and R2 your Row reference.
Problem
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`. How can I write an indirect statement to produce the value in that cell on the other sheet?