Thanks Kamran, This is working fine, I think this is the best possible alternative.
On Tue, 28 Oct 2008 Kamran Haider wrote : > >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 >> Warm Regards, Nidhesh Dhawan Chartered Accountant +91-981-019-9742 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
