Dear friends
Kindly please help,
Excel Drop Downs From List on Different Sheet example if sheet2 has product in A2 and Value in B2 they should appear as dropdown mean Product in Sheet1 A1 and automatic value in B1 image attached for example.
Thank you all
FerozAttachment 649187
Last edited by feroz763; 11-12-2019 at 05:28 AM.
You dont need a DD for the 2nd column, just use a vlookup instead, to find the item from the 1st column
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Vegetable excel.xlsx
please see this excel sheet kindly please correct the formula... thanking you in advance.
Try this...
=VLOOKUP(A1,Sheet2!$A$2:$B$5,2,0)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks