Please find the attactment.
In dropdown list it should show 1 to 7, after entering Instead of 3 it should shows as Wednesday as a result.
Please find the attactment.
In dropdown list it should show 1 to 7, after entering Instead of 3 it should shows as Wednesday as a result.
There is a tricky way to do this that will work if you change the way you list the days to
Then you can use custom formatting in B3 of "dddd" and it will show the name of the corresponding day.Please Login or Register to view this content.
This works because if 1 is interpreted as a date number, it will be 1/1/1900 which was a Sunday.
The only other alternative I can think of is to use a macro that will update the cell each time the user makes a selection.
Hello Sundarvlr,
Is there any specific reason why you want to match a number with the weekday, instead of using weekdays?
The way I see it, is a simple change to select the actual day, as per the sample Workbook attached.
Regards
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
thanks for the response.. i have given the weekday only for example. My actual requirement is value can be anything names, address, or places. i required is data sheet input list and output data should be different.
The reason behind is my display message is lengthy it has more the 40 words. So dont want make it in drop down list.
Ex: dropdown list only show the crisp if select animal, but output will be (lion, tiger, elephant, cat, dog)
Hello Sundarvlr,
In that case I would suggest you look at "Index Match", instead of Data Validation which cannot handle what you want.
Please provide us with your exact requirements, a Workbook showing us a before and desired result, and maybe we might be able to assist you further.
Thanks for taking your efforts to help me out. Please find the attachment.
You still haven't shown what kind of result you want, so I guessed.
In this example, there is a dropdown box that has a list of numbers from 1 to the number of selections in the list in column C. The list itself is stored in Sheet2 and will automatically update if you add more elements in column C. The list is a dynamic named range called PickList. The formulas red shaded area on Sheet2 must be copied down if you need a longer list.
The cell to the right of the dropdown box uses the INDEX function to return the content of the cell that corresponds to the number selected in the dropdown box.
It is not really worth the coding effort to have the user pick a number in the dropdown box then show the full text of the selection in the same cell, and this is a better solution from a user interface standpoint.
sorry...i have not clearly explained. I don't need that much big sentence in the drop down list so i need only alternate sentence like 1. Configuration at beginning: Partially Conformed 2. Configuration at begining: Fully Conformed
Take a look at this.
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
Thanks it works for me....
6String Thanks this formula is very also helpful for me...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks