Is it possible to use a formula in ArcGIS Pro 2.6 that is similar to a VLOOKUP in excel? I have a long list of 4 letter codes that populeate scientific and common names for trees in excel. For example PSME = Pseudotsuga menziesii (Scientific) and Douglas-fir (Common). I would like to just enter the 4-letter code in the field and have the other two attributes auto-populate.
