Learn Excel 2010 - "Unwinding Array" Podcast #1418

Bill Jelen 2011-08-31

Views 29

A VLOOKUP to convert State Codes to State Names all in an Array Formula - and no backward compatibility! Today, in Episode #1418, Bill shows us how to get this issue fixed along with a brief, but informative look at a few ways to work with VLOOKUP.
Show more

Share This Video


Download

  
Report form
RELATED VIDEOS
[PDF] EXCEL: A Beginner's Guide to Microsoft Excel (Excel Microsoft Excel Learn Excel Spreadsheets
play
00:05

[PDF] EXCEL: A Beginner's Guide to Microsoft Excel (Excel Microsoft Excel Learn Excel Spreadsheets
Read EXCEL: A Beginner's Guide to Microsoft Excel (Excel Microsoft Excel Learn Excel Spreadsheets
play
00:05

Read EXCEL: A Beginner's Guide to Microsoft Excel (Excel Microsoft Excel Learn Excel Spreadsheets
How to Use Vlookup to Merge Spreadsheet Data - Match Data in Google Spreadsheets and Excel
play
09:14

How to Use Vlookup to Merge Spreadsheet Data - Match Data in Google Spreadsheets and Excel
Read Excel 2007/ Excel Hacks: Los mejores trucos/ Tips Tools for Streamlining Your Spreadsheets
play
00:27

Read Excel 2007/ Excel Hacks: Los mejores trucos/ Tips Tools for Streamlining Your Spreadsheets
PDF Excel for Auditors Audit Spreadsheets Using Excel 97 through Excel 2007 Download Full Ebook
play
00:28

PDF Excel for Auditors Audit Spreadsheets Using Excel 97 through Excel 2007 Download Full Ebook
How to extract e-mail addresses from Excel Spreadsheets (or multiple excel files)
play
03:09

How to extract e-mail addresses from Excel Spreadsheets (or multiple excel files)
How to Excel Delete Remove Duplicates and Duplicate Cells Data from Multiple Excel Spreadsheets
play
01:26

How to Excel Delete Remove Duplicates and Duplicate Cells Data from Multiple Excel Spreadsheets
Professional Excel Templates And Spreadsheets
play
00:57

Professional Excel Templates And Spreadsheets
MS Excel Setting Passwords in Existing Spreadsheets
play
00:42

MS Excel Setting Passwords in Existing Spreadsheets
How to print multiple excel spreadsheets (& worksheets) at once
play
02:31

How to print multiple excel spreadsheets (& worksheets) at once
How to Extract Data and Text from Multiple Excel Spreadsheets at once
play
02:56

How to Extract Data and Text from Multiple Excel Spreadsheets at once
How to print multiple excel spreadsheets at once (including active sheets)
play
01:14

How to print multiple excel spreadsheets at once (including active sheets)