«
»

Excel Magic Trick 334: VLOOKUP & Data Validation for Invoice

See how to use VLOOKUP & Data Validation to make an Invoice when the Product List is on a different Sheet or different Workbook. See the functions VLOOKUP, COLUMNS and IF. See Data Validation List from a different worksheet or Workbook. See how to name a range of cells. Learn about workbook & worksheet cell references in formulas.

Worksheet and Workbook References in formulas and VLOOKUP function.

Duration : 0:10:55


Technorati Tags: , , , , , , , , , , , , , ,

Related posts:

  1. Excel Basics #23: VLOOKUP function formula
  2. Excel Magic Trick 398: VLOOKUP with Two Lookup Values (IFERROR function also) 2 lookup values
  3. Excel Magic Trick 684: VLOOKUP 1 item & Add Values from Multiple Rows/Columns – HLOOKUP
  4. Excel Magic Trick 167p1 IF function formula: 12 Examples!
  5. Excel Lookup Series #2: VLOOKUP Function 2nd Example

Tags: , , , , , , , , , , , , , ,

This entry was posted on Thursday, August 26th, 2010 at 11:13 pm and is filed under Learn Excel Formulas. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply