Dear All , I made efforts to resolve below issue by trick .I attached the solution sheet .I just create another field that count all the repetative values so by combining thiere count with actual field i get primary key that i can use for lookup .Please have the attached solution sheet . I m greatfull to you if you give feedback on this solution .Allah Hafiz ,Kamran Haider .
Date: Sun, 26 Oct 2008 11:29:22 +0530From: [EMAIL PROTECTED]: [EMAIL PROTECTED]: $$Excel-Macros$$ Re: Lookup for repetitive items hi nishant, Pls send me the solution to me. Regards M.A. Swaminadane On Thu, Oct 23, 2008 at 11:51 PM, Nishant Jain <[EMAIL PROTECTED]> wrote: I have send you the solution on email.NishantOn Oct 23, 4:56 pm, 'Nidhesh Dhawan' <[EMAIL PROTECTED]> wrote:> Hi all,>> I need to apply lookup for repetitive items, if I use normal vlookup, it returns the value with matches with the first record.>> Is there any way to get 1st value for 1st record and to skip that record subsequenly.>> The above problem is explained in the attached sheet.>> P.S. Would prefer an excel solution rather than a code.>> Pls help !!.>> Thanks,> Nidhesh>> Vlookup_Rep_items.xls> 31KViewDownload<br_________________________________________________________________ Discover the new Windows Vista http://search.msn.com/results.aspx?q=windows+vista&mkt=en-US&form=QBRE --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
repetive lookup solution.xls
Description: MS-Excel spreadsheet
