INDIRECT with column reference and row reference in different cells

excel excel-formula worksheet-function excel-indirect
user3037024 picture user3037024 · Nov 26, 2013 · Viewed 17.4k times · Source

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?

Answer

pnuts picture pnuts · Nov 26, 2013

Please try: 

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

where U2 contains your Column reference and R2 your Row reference.

Related questions

Returning cell values from other sheets by referencing sheet names from a list

I have a spreadsheet with approx twenty different sheets named by stock ticker. Because these are templates, the information in each sheet is found in the same cells. For example, the EPS for the current year is always in cell …

Read More
Adding previous cell and current cell functions

I like to have an Excel Function for: Previous cell + Current Cell = Current cell to do this function for the entire row, when I enter a new value each time, Eg. A1+A2= A2.

Read More
Automatically increment sheet reference when dragging formula

I have a formula with the following syntax: =SheetName!E10 and need some way to drag the formula and change just the sheet name as it moves to the right. So the E10 part needs to stay the same with …

Read More