I'm looking for a VBA code for exact and closely matching text.
Please find the scenario below
If I enter any of the regions(AD,FE,EU) in another new excel sheet, then it must extract the codes from column D closely matching along with the region name in column E
E.g. If I enter Aalborg, then result must appear like below
Search Criteria : Aalborg