Dear nidheshd , Please have solution file .Please give your feedback on the solution . Allah Hafiz ,Kamran Haider .
Date: Thu, 23 Oct 2008 11:56:13 +0000From: [EMAIL PROTECTED]: [EMAIL PROTECTED]: $$Excel-Macros$$ Lookup for repetitive itemsHi 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 </Table_________________________________________________________________ Explore the seven wonders of the world http://search.msn.com/results.aspx?q=7+wonders+world&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 -~----------~----~----~----~------~----~------~--~---
Vlookup_Rep_items(1).xls
Description: MS-Excel spreadsheet
