Hey thanks alot all of you guys .. all the sheets serves my purpose but Ajit I found ur solution more easy to use ... Kamran yous solution is abit complicated but still thanks for the solution .... I'll try to understand it ...
Many thanks to all Regards Mahreen On Mon, Nov 17, 2008 at 12:36 AM, Kamran Haider <[EMAIL PROTECTED] > wrote: > > > I found only one way may it works for you .Please inform me if it solve > your problem . > > > Allah Hafiz , > Kamran Haider . > > > > > > > ------------------------------ > > Date: Sun, 16 Nov 2008 07:25:42 -0800 > From: [EMAIL PROTECTED] > > To: excel-macros@googlegroups.com > Subject: $$Excel-Macros$$ VLOOKUP with multiple dependents > > > Hi All > > I have a little query regarding VLOOKUP Formula. I have been using it > depending on only one value. But now I want to use for two dependents. The > attached file has two sheets one with the master data and the other one > where I extract data using VLOOKUP. > > *Customer No.* *Proposal No.* *Name* *Address* *Contact No.* > *Outstanding > Amount* *DPD* 360 1 Azhar ab 231 1000000 10 > > I am able to extract data with column named Customer No. but in my master > sheet I have same customer with several proposal no.s and their subsequent > different info. For instance there are 4 proposals in my master sheet for > customer no. 360. When I use vlookup, excel shows customer no. with only > proposal no. 1. I want to manually enter the customer & proposal no. in > column a2 & b2 respectively and the info shows should be of Customer no. 360 > with customer no. 1,2,3 or 4 (whichever specified in b2 by me). Kindly help > for the same as I have around 2000 enteries to work with. > Any help shall be appreciated. > > Regards > Mahreen > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---