If the sheet name is changed, the reference should update automatically.
When the evaluation succeeds, INDIRECT converts the text into a valid reference.
TheVLOOKUP functionis used to perform the lookup.
“Jan”, “Feb”, “Mar”).
A single quote character is joined to either side of C$4 using theconcatenationoperator(&).
Next, the exclamation point (!)
We provide zero (0) forrange_lookupto force an exact match.
As the formula is copied down and across, VLOOKUP retrieves the correct values from each sheet.
However, because we are using alookup operationto retrieve the monthly values, this does not matter.
INDIRECT is useful when you want to assemble a text value that can be used as a valid reference.
