• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dropdown List/Vlookup in same cell

T

Thea

New Member
I need to put a vlookup in the same cells that there is already drop down lists. Is there anyway this is possible?
 
No, why would you want to do this, think through your problem and what you are trying to achieve
 
Hi ,

If a cell has Data Validation associated with it , it means that you are allowing the user to enter data in it , and this user entered data will be validated by the DV rules that have been created. If the DV rule is a list , then the user is allowed to either enter data which is allowed by the list , or select any item from the list.

A cell which has a formula already entered in it , can now have a DV rule associated with it , but the moment a user enters data into the cell , the formula will be overwritten with the user-entered data.

Narayan
 
You must log in or register to reply here.
Back
Top