Hi all,
I am not sure what it would take to accomplish this in excel so apologies if this is not in the correct forum.
Lets assume there is a "user input" field in one worksheet, this field then looks at another sheet which has a list of potential matches (for the full word group or single words) in one column that is accompanied by another column with its defined abbreviation. (example below)
Also any space in the user input field should be replaced with a _ (underscore). I understand looking at each word in this case would not work as the "Air Handling Unit" is 3 words but the set should result in AHU. so this adds to the complexity. As it should look for a match for the whole set in parts and resolve the individual words remaining essentially.
Sheet 1
Column A
User Input
Air Handling Unit Airflow Actuator
Column B
Result
AHU_AF_ACTR
Sheet 2
Column A Column B
Full Name Abbreviation
ACTUATOR ACTR
AIRFLOW AF
AIR HANDLING UNIT AHU
ALARM ALM
AMPERAGE AMP
AVERAGE AVG
BUILDING BLDG
What would be needed to achieve this functionality?
I am using Excel 2010 but have access to newer versions as well.
Screenshots attached.
Greatly appreciate any help.
2016-10-12_21h56_22.png2016-10-12_21h57_41.png
Bookmarks