LOOKUP Array & Index Function (Search data across multiple sheets)

**dizzle** · 06-27-2013, 11:26 AM

I don't know anything about Array's and the Index Function, and reading about them right now makes me want to cry (just can't wrap my brain around it) but I know that that is what I (think) need to properly create what I want.

I've attached the sample sheet to give you an idea of what I'm looking to accomplish.

In the CS (Red) Sheet, I have all the unique identifiers. Column B will be a manually entered in column, and column C is where I will need the forumla.

I need the function to search all sheets (New sheets will be added monthly) for the 4 digit code and sum up the entire row from Column "X" to Column "X" (x/y are variables).

Thanks in advance for all your guy's help!!

**dilipandey** · 06-30-2013, 01:56 PM

Hi dizzle,

You need formula in column C but in which sheet ?
In CS sheet, column C is hidden and for other sheets, column C would contain data to sum .. correct or I am missing something ?

Regards,
DILIPandey
<click on below * if this helps>

**dizzle** · 07-01-2013, 10:25 AM

New thread: http://www.excelforum.com/excel-form...82#post3303782

**dilipandey** · 07-02-2013, 09:26 AM

Okay.. then please mark this thread as [SOLVED] or connect with a MOD to remove this altogether - may be MODs can better decide what to do once you report this thread to them

Regards,
DILIPandey
<click on below * if this helps>