Daily Dose of Excel » Blog Archive » VLOOKUP and INDIRECT

The INDIRECT function can be used to return a range to the VLOOKUP formula. Andy provides this example where the sheet is different for every row, but he doesn’t want to change the formula manually. I could see this being useful when the lookup value ...

dailydoseofexcel.com