David, Thanks so much for your efforts. I'll start with this and see if I can come up with something. I do however need to change the vlookup to an index,match due to the size the vlookup will make the file. Index,match makes the file size smaller, at least from what I've found in using both.
If anyone else has an idea on how to finish David's efforts but using index,match I welcome it. If I find the solution, I'll post it. Thanks all. ________________________________ From: who <dlanm...@att.net> To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> Sent: Sun, August 1, 2010 8:18:49 PM Subject: $$Excel-Macros$$ Re: Need specific info on unique combination Hi, This is close, but not quite there. The lookup is in cell A1, and there are two tables, B2 thru C15 and D2 thru E15. The Formula is in cell A2. It still needs some work, but I think the concept is there. 15 T1 1 1 15 15 2 2 16 16 3 3 17 17 4 4 18 18 5 5 19 19 6 6 20 20 7 7 21 21 8 8 22 22 9 9 23 23 10 10 24 24 11 11 25 25 12 12 26 26 13 13 27 27 14 14 28 28 =IF(IF(ISERROR(VLOOKUP(A1,B2:C15,1,FALSE)),"", (VLOOKUP(A1,B2:C15,1,FALSE)))="","T1", (VLOOKUP(A1,B2:C15,1,FALSE))) Above is the formula is cell A2. I think replace the "T1" with either lookup for the actual lookup. Hope it comes close enough that someone here can figure it out. Thanks, David L On Aug 1, 8:24 am, Nadine S <n8dine4ma...@yahoo.com> wrote: > Resending with a subject. Sorry. > > ________________________________ > > I have information in the first three cells of a worksheet and in the forth > is >a > Yes or No. > In worksheet 2 the first three columns contain the same type of information as > in sheet1 but sheet 1 can list that information multiple times whereas sheet 2 > only lists that unique combination once. > Example: > Sheet 1: > Col A Col B Col C Col D > AA12345 9944567234 HH Yes > AA12345 9944567234 HH No > AA12345 9944567234 HH Yes > > SHeet 2: > Col A Col B Col C Col F > AA12345 9944567234 HH > > What I need in Col F on sheet2 is a formula that will look for all records in > sheet 1 that match the unique combination in sheet 2 and give me a No if there > are any No's in Col D on sheet 1. If all are Yes on Sheet1 then of course I > need a Yes in sheet 2 Col F. > > Anyone know how to write this formula in Excel 2003? 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 -- ---------------------------------------------------------------------------------- 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
