Instead of creating a drop down menu to pull data from another range of cells, can I have the data pulled up by matching? I.e., as a name is being typed, excel automatically matches it to names in the data validation area.
Instead of creating a drop down menu to pull data from another range of cells, can I have the data pulled up by matching? I.e., as a name is being typed, excel automatically matches it to names in the data validation area.
Try searching the forum for "match" and "index". There are lots of similar problems and answers here.
Trish in Oz
-------------
A problem well defined is a puzzle half solved
If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
http://www.excelforum.com/faq.php?fa...b3_attachments
I did search but couldn't find anything for what I want to do and the ones that seemed to might be on the right track, I couldn't figure out the codes.
Can no one help me? I know this may seem like a basic thing to do for all the experts in here, but for me, it isn't.
All I know is that Excel will automatically match names when they're typed in the same column, but I don't know how to get that function to work when the data is located in a different column.
I don't think what you're asking for is possible.
Excel doesn't recognize what you type until you press enter.
The autocomplete function that is built in Excel is part of the Excel software itself.
I think you may be able to do something similar using listboxes or comboboxes (which are a sort of dropdowns as you mentioned earlier).
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks