#1
|
|||
|
|||
Index Match Function across different worksheets
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 |
#2
|
||||
|
||||
Hi and welcome to the board the easiest ay would be to merge all sheets and work with the summary See http://www.rondebruin.nl/win/addins/rdbmerge.htm for the merging part
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
||||
|
||||
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
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 |