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 1,000,000 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
-~----------~----~----~----~------~----~------~--~---
VLOOKUP(1).xls
Description: MS-Excel spreadsheet
