Forum Discussion
Create new worksheet with one graph using single cell input from multiple worksheets
GIVEN: - I have an Excel 2003 (don't yell at me!) spreadsheet with multiple worksheets. - Each worksheet has two columns (text label, numeric value) and a graph showing all the columns' values. - ...
Perhaps the same could be done directly in Excel 2003, but with INDEX/MATCH or VLOOKUP instead of XLOOKUP
The formula in C2 for Excel 2019 and earlier could be
=VLOOKUP("TOTAL", INDIRECT("'"&B2&"'!A:B"), 2, FALSE)