J jskushawah New Member Jul 25, 2012 #1 How can we use offset() function to generate a dynamic report.
Hui Excel Ninja Staff member Jul 25, 2012 #2 Yes You may want to read: http://chandoo.org/wp/2008/11/19/vlookup-match-and-offset-explained-in-plain-english-spreadcheats/ or an example of it in use here: http://chandoo.org/wp/2010/11/04/analysing-large-tables/
Yes You may want to read: http://chandoo.org/wp/2008/11/19/vlookup-match-and-offset-explained-in-plain-english-spreadcheats/ or an example of it in use here: http://chandoo.org/wp/2010/11/04/analysing-large-tables/
