Dear friend, I think there is also some problem with sheet name".xls]ratelist" as sheet name can not have "]" . still i will suggest the solution that name the array and then apply vlookup it will work. I have tried it. rgds
Mayank On Sat, Aug 30, 2008 at 2:38 PM, Palani Durai <[EMAIL PROTECTED]>wrote: > Hi Yasir, > > I do recognize, there is a simple solution im seeing is that you have > create a unique ID of the combination of "Code" & "Color" based on that you > can have your values by vlookup..... > > the sheet is attached herewith... > > > > > On 8/30/08, yasir_shahjee <[EMAIL PROTECTED]> wrote: >> >> Dear palani >> >> I am member of $$Excle-macros$$ one time you was help me about trali >> detail >> >> Dear now i hve another problem i attached sheet kindly check it. >> >> thanks and regards >> >> -- >> Masoom Dost >> >> >> >> > > > > -- Regards Mayank Patel 9822978041 9422749110 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
