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?
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…