Hi all,
i have problem hope master here able to help me, let say have database consist of 2 columns and i create dropdown menu and refer to the first column in that database, and when i choose one of the item in dropdown it will show item in the second column in database. Do you guys know how to code it?thanks in advance
Hi mtsf,
See the attachment where I used below formula next to 1 :-
Formula:
Please Login or Register to view this content.
tst.xlsx
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
Hi Dilipandey,
Thanks for reply me, btw what i need here automatically in the same cell so no need to add formula in another cell, is it possible?
In the same cell where you have dropdown or in the cell on right side ?
Regards,
DILIPandey
<click on below * if this helps>
in the same cell where i have dropdown...is it possible?
short answer...no, it's not possible with regular formulas and functions. you can have either a value in a cell or a formula...not both
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
HI FDibbins,
Thanks for the reply, so for this case need to use macro then?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks