Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 66th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to pull data from a table on one worksheet to a second worksheet using the VLOOKUP and DGET functions.
Just updated your iPhone to iOS 18? You'll find a ton of hot new features for some of your most-used Apple apps. Dive in and see for yourself:
How To:
Generate random numbers (with decimals) in Excel
How To:
Create a Basic Attendance Sheet in Excel
How To:
Multiply column times row with Transpose in MS Excel
How To:
Create a Tangent Line with Excel
How To:
Conditionally format at every change in value in Excel
How To:
Change Excel options directly in the Registry
How To:
Do matrix multiplication and inverse in MS Excel
How To:
Create a bond discount or premium amortization table in Excel
How To:
Calculate Commission Based on Varying Rates in Excel
How To:
Use VLOOKUP across worksheets in MS Excel 2007
How To:
Clear data & cell contents in Excel using a macro
How To:
Find a P-Value with Excel
How To:
Create dynamic sub tables in Microsoft Excel
How To:
Hide scroll bars, sheet tabs & charts in Excel
How To:
Build a 15-minute schedule in Microsoft Excel
How To:
Graph the probability density function in an Excel file
How To:
Create a dynamic weekly chart in Microsoft Excel
How To:
Save Your Word Document as PDF with One Click (Using a Macro)
How To:
Measure the spread of a data set with Excel's AVEDEV
How To:
Create a table for the VLOOKUP function in Excel
How To:
Generate random numbers (with decimals) in Excel
How To:
Create a Basic Attendance Sheet in Excel
How To:
Multiply column times row with Transpose in MS Excel
How To:
Create a Tangent Line with Excel
How To:
Conditionally format at every change in value in Excel
How To:
Change Excel options directly in the Registry
How To:
Create a bond discount or premium amortization table in Excel
How To:
Do matrix multiplication and inverse in MS Excel
How To:
Calculate Commission Based on Varying Rates in Excel
How To:
Use VLOOKUP across worksheets in MS Excel 2007
How To:
Clear data & cell contents in Excel using a macro
How To:
Find a P-Value with Excel
How To:
Create dynamic sub tables in Microsoft Excel
How To:
Hide scroll bars, sheet tabs & charts in Excel
How To:
Build a 15-minute schedule in Microsoft Excel
How To:
Save Your Word Document as PDF with One Click (Using a Macro)
How To:
Insert and format a text box in Microsoft Word for Mac 2011
How To:
Graph the probability density function in an Excel file
How To:
Measure the spread of a data set with Excel's AVEDEV
How To:
Create a table for the VLOOKUP function in Excel
1 Comment
I am trying in excell to create a worksheet within a workbook that will pull data ( date) from another worksheet there are 15 cells in column. and these must match another column and this column contains a certain county, there may be 7 - 10 different counties. If you can help I can send you the workbook so you can look at the problem.
Share Your Thoughts