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 --~--~---------~--~----~------------~-------~--~----~ 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.xls
Description: Binary data
