|
|
#1
04-27-2015, 05:18 AM
|
|||
|
|||
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
04-27-2015, 05:56 AM
|
||||
|
||||
|
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
04-27-2015, 06:04 AM
|
||||
|
||||
|
__________________
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 |
Windows 8 
Office 2013
Linear Mode
