I am semi-familiar with using wild cards in VLOOKUP formulas. However this has always been with the ‘lookup_value’ being the item with the wild card.
I am trying to reclassify a large data set where a range of lookup values relate to one classification and to do this I would like to use the wildcard in the in ‘table_array’ as shown below. Or said another way one value in the table array (ED.OPR.ADV.*) will be found by multiple lookup values (ED.OPR.ADV.BFM.SUP and ED.OPR.ADV.DCM.SAL).
However when I set up my VLOOKUP it returns the value #N/A. Is there a way to perform this function or to set-up my data differently to allow this to run. I have countless permutations of ED.OPR.ADV.* in the data set and I would like to classify all as personal costs.
In case that image is not working I have added table to GoogleDocs: https://drive.google.com/file/d/1BCD...ew?usp=sharing