Nov 21, 2013 · First you need to create a table of codes, descriptions and costs. This can be in some unused cells off to the right or on another worksheet. The you will use VLOOKUP () to …

Aug 3, 2016 · You'll need two things: The size extracted from the right of your code. Let's suppose the columns C and D have your Cabinet Types and Descriptions respectively. Let's also …

Apr 16, 2024 · I want the spreadsheet to automatically produce a corresponding description in one cell when the foremen put in the code in another cell. For example, when he inputs the …

Jul 19, 2006 · I want to be able to enter a product code in one column and based on the code i have entered, get the product description to automatically appear in the column next to it.

Jul 13, 2024 · As per your description, to achieve the autofill of product descriptions based on product codes entered in any order in a separate tab in Excel, you can use INDEX/MATCH …

I would like to be able to type an item code into a cell and in the two cells to the right automatically populate the description and the price. Type "Temporary Wire" in A2, and "Installing a …

Nov 24, 2010 · In Excel 2007, how do I add a description and parameter hints to a user-defined function? When I start typing a function invocation for a built-in function, Excel shows a …

I want the user to pick a code from a list of valid values in column 'H', then have the code description populate automatically in column 'I'. Column 'H' has a validation list on another tab …

Jul 8, 2024 · Writing VBA (Visual Basic for Applications) code in Excel can seem daunting at first, but it’s essentially about automating tasks and adding functionality beyond what’s available …

Jul 23, 2013 · When you use the “FunctionDescription” macro to add description to your own custom VBA functions you should change the following lines of code (red color), according to …