Index Formula

[KelvinBruns]

Hello:
I am trying to see if it possible to use the INDEX formula to look at more then one worksheet.

Worksheet A - Is where the formula is being typed and I need the data to be returned in.

Worksheet B - This is where the raw data is located. The data is on 26 separate worksheets. Column A has the information that is being used to reference the data.

I need the formula in Worksheet A to look in all 26 sheets and return values from column E:P.

Currently I have to do a new formula every time I go to gather data from another sheet.

Any thoughts or opinions would be greatly appreciated!

Kelvin

 

[jorismoerings]

Hi Kelvin,

If your not dead set to Index Match take a look at this: http://www.mrexcel.com/forum/excel-questions/679486-index-match-across-multiple-worksheets.html