Forum Discussion
Solved
Extract cell on a different worksheet indirectly via a heading cell
I'm using Excel 2016 and would like to use the Heading "220625 AC" in the formula to fetch the time from the worksheet instead of modifying the formula in each column. =IF(ISNUMBER(VLOOKUP(RC1...
INDIRECT uses A1-style referencing by default. To use R1C1-style, specify FALSE as second argument:
=VLOOKUP(RC1,INDIRECT("'"&R1C&"'!C3:C4",FALSE),2,FALSE)
INDIRECT uses A1-style referencing by default. To use R1C1-style, specify FALSE as second argument:
=VLOOKUP(RC1,INDIRECT("'"&R1C&"'!C3:C4",FALSE),2,FALSE)
Clogs, aye? Love it! Thanks, too obvious.