Hi,
I'm having some problems with a Developer table an need help. I've created a drop down menu from a list (attached). The only this is, once I select the appropriate selection from the menu, I also want to generate what # that selection is from the list (i.e. "Delta" is #2, "Foxtrot" is 8). I have to somehow link the # it is in the list to the output of the drop down menu.Can anyone help me?
Thanks!
Hi,
Try this formula:
Formula:
Please Login or Register to view this content.
abousetta
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
Nope, does not work, I receive an "#NA" error
It should have given you a circular error?! Let's try this again...
put this formula in G7
Formula:Please Login or Register to view this content.
F7 = result of the combobox
$B$3:$B$10 = array of cells containing list of possible options in combobox
0 = exact match only
This thread has been opened in the commercial services subforum, hence locked.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks