Index Match Function across different worksheets

shay_mt · #1 04-27-2015, 05:18 AM

Hi

I have 12 sheets every sheet present a month
Every sheet have the following table (all sheets have the same table)
Column A for Date
Column B for Name
Column C for Quantity

monthly sheet.JPG

Also I have summary sheet that present the higher quantity using MAX formula that crossing on all the sheets

summary sheet.JPG

I would like an Index Match formula to search the name or the date of the quantity in C2

Thanks in advance

Shay

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Translate INDEX(MATCH) into VBA	grexcelman	Excel Programming	1	03-08-2015 05:06 PM
Index match vba	grexcelman	Excel	0	03-05-2015 10:55 PM
Index Match function	jackzha	Excel	5	12-03-2014 12:43 PM
I need an index file containing the names of all the worksheets in a workbook.	retiredstuart	Excel	3	09-12-2014 06:26 AM
Moving a Index/Match function	FraserKitchell	Excel	2	01-19-2010 09:38 AM