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 -0800From: [EMAIL PROTECTED]: [EMAIL PROTECTED]: $$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_________________________________________________________________ Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy! http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us --~--~---------~--~----~------------~-------~--~----~ 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(1).xls
Description: MS-Excel spreadsheet
