Would really appreciate if you give others some time to think.. Thanks !!
~Cheers, Krishnan Moorthy P Please consider the environment before printing this e-mail. ツ♫♪ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Nadine S Sent: Friday, July 30, 2010 4:26 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Index match with 3 criteria I sent this email this morning and haven't heard back. I really really hope someone can help with this because I truly have no clue on how to make this work and really need it to. I know I could do a concatenation cell in each sheet and search that way but I'd really like to keep it cleaner. Thanks again. _____ From: Nadine S <n8dine4ma...@yahoo.com> To: excel-macros@googlegroups.com Sent: Thu, July 29, 2010 7:28:24 AM Subject: Re: $$Excel-Macros$$ Index match with 3 criteria 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 <http://clk.atdmt.com/NMN/go/157639755/direct/01/> 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 <http://www.excel-macros.blogspot.com/> 4. Learn VBA Macros at http://www.quickvba.blogspot.com <http://www.quickvba.blogspot.com/> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com <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
