#1
|
|||
|
|||
Help with multiple match and index formula
Hello all I was wondering if any one could please give me advice on my current problem with excel. I need to compare and copy values between two different sheets. I receive an invoice every month which contains a lot of the same data is there a way I can compare the values in columns f,g and j and if they all match insert the value from L from my old invoice to my new one. Any help would be greatly appreciated. Thanks Ryan |
#2
|
|||
|
|||
Help with multiple match and index formula
Try this one...
=INDEX($E$2:$E$7,MATCH(1,INDEX(("Adult"=$B$2:$B$7) *("Art"=$D$2:$D$7),0,0),0)) Enclosed is also another one using an Array formula... Cheers |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula that can merge multiple rows with the same ID into one row | Hilwey | Excel | 3 | 07-08-2015 08:50 PM |
Vlookup or Index/Match - Multiple Criteria | ruci1225 | Excel | 1 | 01-15-2012 07:31 AM |
Word 2010 / Master Index / Multiple Documents | bawrites | Word | 0 | 08-09-2011 11:02 AM |
Moving a Index/Match function | FraserKitchell | Excel | 2 | 01-19-2010 09:38 AM |
Need another formula to match my last one | tinkertron | Excel | 2 | 04-29-2009 02:17 PM |