Re: Lookup value in multiple worksheets, return values in Row1, 2, & 3 in corresp. co
Given that I do not have Excel 2010 (I have 2003), does any one know of a way to modify the following formula so that it will look at all 5 sheets in the workbook (not just the '2000' sheet)?
I only need the formula to look at the same row in each sheet (i.e. Row 6 as in the above example). Once the formula is working, I can change the row reference as needed to return the additional results.