Forum Discussion

tjveneri's avatar
tjveneri
Copper Contributor
Jan 25, 2023

Insert formula within quotations referencing a different sheet.

I have a sheet for every day of the month that feeds into a central sheet so that the data is easier to work with. Each row is associated with a date in "MM/DD/YY" format in the central sheet and the...
excel
Formulas and Functions
Rodrigo_'s avatar
Rodrigo_
Steel Contributor
Jan 25, 2023

Hello tjveneri,

Try this sample, 

 

 

formula on B2:

=IFERROR(INDIRECT("'"&DAY($A2)&"'!$H$8"),"")

 

File is on the attached.