Hi Nadine, Have a look at the formula. The $M$2:$M$5 shoukd be $R$2:$R$5
Regards - Dave. Date: Thu, 29 Jul 2010 07:28:24 -0700 From: n8dine4ma...@yahoo.com Subject: Re: $$Excel-Macros$$ Index match with 3 criteria To: excel-macros@googlegroups.com This worked originally but for some reason isn't working now. I've included the file which is my file I'm working with and not the sample any more. The data in the Extract will vary in length. I have the exact same formula in your sample but it's not working now. Can anyone figure out what's wrong? I appreciate all the help. Nadine From: Dave Bonallack <davebonall...@hotmail.com> To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com> Sent: Sat, July 17, 2010 1:07:56 AM Subject: RE: $$Excel-Macros$$ Index match with 3 criteria Hi Nadine, Have a look at the attached to see if it does what you need. I've used array formulas, so I don't know how it will go if your actual file is very large. There's a couple of #NA's in the list because they have no match. Regards - Dave. Date: Fri, 16 Jul 2010 10:16:13 -0700 From: n8dine4ma...@yahoo.com Subject: $$Excel-Macros$$ Index match with 3 criteria To: excel-macros@googlegroups.com Here is a sample sheet that explains what I need. 3 columns in sheet 1 need to match the same in sheet 2 and return an item from sheet2. Thanks. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Australia's #1 job site If It Exists, You'll Find it on SEEK -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
