I have a series of numeric codes in column E of spreadsheet A (i.e. 21 55 00 80 14 02 10). I want to pull the description for these codes from spreadsheet B which also contains the codes and their associated descriptions
How would you approach this situation? Would you use Open Database Connectivity (OBDC) to accomplish this is is there some better way to do this?