I have sheets that are all identical in their structure, and I have a cell that is returning the appropriate sheet name. I'm wanting to refer to this cell in a formula to lookup the sheet name with the corresponding cell reference in that chosen sheet.
To give a real example, the sheet names are 1Units, 2Units, 3Units, 4Units, and the appropriate one is now returned in cell E33. My end result is grabbing required info with an Index Match. Here is what I'm chasing (but knowing I haven't displayed the formula correctly to join the sheet reference with the cell/s in that sheet). Any assistance to correct would be fantastic.
=index(E33!A13:A23,match(P5,E33!B13:B23))
To give a real example, the sheet names are 1Units, 2Units, 3Units, 4Units, and the appropriate one is now returned in cell E33. My end result is grabbing required info with an Index Match. Here is what I'm chasing (but knowing I haven't displayed the formula correctly to join the sheet reference with the cell/s in that sheet). Any assistance to correct would be fantastic.
=index(E33!A13:A23,match(P5,E33!B13:B23))