Excel drop down list to convert full name & enter Abbreviations
I have a database called Overtime with a second sheet called data. On the first sheet I am using data validation to access the data list on the data page. At present The list has peoples full names. What I want to do is when a name is selected it then changes it to the Initials from the Data sheet. Not sure if this can be done into the one cell, or to use something like Vlookup to enter the initials into an adjacent cell. The names and Initials are on the same rows on the data page (in columns "I" & "J"). On the main database the validation list is for column "O". I have a column "P" ready to put in the formula to show the initials if this the only way it can be done.
Solution
With data in the Data sheet like:
In P1 enter:
=IF(OR(O1="",NOT(ISNUMBER(MATCH(O1,Data!I:I,0)))),"",VLOOKUP(O1,Data!I:J,2,FALSE))
and copy down.
- Easiest way to loop through a filtered list with VBA?
- VBA Hide Rows in Sheet Based on the Vlookup Value in a Named Range
- VBA run-time error '-2147221080 (800401a8)' automation error
- Excel VBA - Check if connected to internet AND if its via Wifi or Ethernet
- Remove space between an id number
- Upload file to SharePoint using REST API
- Identify Week Number, Month Number, Year from DatePicker control in VBA userform
- Enter Parameter Value Dialog Box when opening form
- Change colour of text in square brackets
- How to use Excel VBA to run WinSCP Script?
- Loop through rows in Excel to pick information to send Outlook emails runs into error on the second row
- Problem with cycling through Styles to change NextParagraphStyle - Run time error 91 - Word vba
- Excel VBA Type mismatch error with Evaluate
- Testing for NaN in VBA/VB6
- MailMergeDataSource Find Record function leads to Execute Merge Failure
- How can export all part of columns to pdf file with VBA code?
- Moving Files in MSOffice Access 2010
- How to repeat a loop until the end of my spreadsheet?
- How to get the squared symbol (²) to display in a string
- How to adjust width or position between label on y-axis?
- Filters and then sorting
- How to avoid using Select in Excel VBA?
- How do I get a range's address including the worksheet name, but not the workbook name, in Excel VBA?
- Euro symbol not showing (VBA)
- How to extract a word in a string between two similar characters" with VBA?
- Beginner is stuck with EXCEL ETL
- How do I download CSV file from investing.com
- Edit links to a new month's file
- VBA - Copy column data to new column, if data exists, use column to the right
- VBA: initializing a string array