Spreadsheets Tips: Vlookup, Arrayformula, Iferror explained - match data from another worksheet
Google Forms for car sales
Find the link to the Google Form here:
drive.google.com/open?id=1Zo2lZgzb5h7NIA2y7PwnkGekqg_OnR1CzbvmA6bPccs
Find a link to the spreadsheet here:
drive.google.com/open?id=14p0zjR8yeQpJtOz1DoWpTddcOw4_sqkU8n_mtALgXio
This video goes through an example of using Vlookup, Arrayformula & iferror functions. This also uses Google Forms to gather the data.
We create a database for a second hand used car company. We included a database of cars from Ford, Kia and Fiat and the use the Match and Index to log customer sales. This concept can be used for multiple different applications with a Sales industry using Google Sheets.
Check out other videos on Spreadsheets below.
Spreadsheet Tips and Tricks : youtu.be/TEqu0Gek7IQ?list=PLD6lc2e8uYopx0ZkDSCIyZgwJwxM3CfzY
Spreadsheet Challenges : youtu.be/Y5yNKPclF3g?list=PLD6lc2e8uYoooVHKX6A73d9yrIe2BPyLo
Timelines in Learning - youtu.be/lEiF1YguM6Y?list=PLD6lc2e8uYoo9Jj8l0fO-0wvH_zlRjfeN
Spreadsheets in Art - youtu.be/vu1E_o1ogQQ?list=PLD6lc2e8uYorjL7E3Ci4ojp9MGutWIuVO
Teach Percentages using Spreadsheets - youtu.be/IJLnuD9WtJQ?list=PLD6lc2e8uYopTYP7Dvh4JGwC9Ih-1qSr1
Create a Times Table Quiz with Spreadsheets - youtu.be/1b0DPsi2tYg?list=PLD6lc2e8uYopnECM3VqYCbNSTn-8jrcYv
Check out the Edtech Files with great ideas for teaching
youtu.be/DMKi32qnpJQ?list=PLD6lc2e8uYoqWXtkKFTjpopKNNBBGwr6M
Check out a full range of videos on Google Classroom
youtu.be/DTZnnrE8MZE?list=PLD6lc2e8uYoqANwI32z_wrPd-NfB0Dsr4
What's New in Google
youtu.be/wbgqV8RtS7I?list=PLD6lc2e8uYoqrzO-NodDhu1JQ7tLHPtGN
The New Google Sites
youtu.be/erH80dmZMTw?list=PLD6lc2e8uYoo8_d1Ro__RkqsM7rzaH-CF
Create Living pictures
youtu.be/rf1a2BgpqOM?list=PLD6lc2e8uYoqzo5yrC_9g9gfnZgk55gxT
iMovie hints and tips
youtu.be/gxBgnxdO3xo?list=PLD6lc2e8uYopVvYaSs1fT0Wz-_j1scGDU
Maps in learning
youtu.be/s0b85yqdunA?list=PLD6lc2e8uYorynNPSZqdjcVQG12HSCgXL
The Quicktime Series
Create a Movie Recording - youtu.be/ABAkzPoaosc
Create an Audio Recording - youtu.be/beEbtC7dv08
Create a Screencast Recording - youtu.be/hncflzJGQYw
Screencast your Apple Device - youtu.be/h-2izK8B2Ds
Edit your movies in Quicktime - youtu.be/iz7DuvW84W4
Export and Share your movies - youtu.be/PlkqRVDZidw
Picture in Picture - youtu.be/jcsevtCqMOg
Google My Maps
youtube.com/playlist?list=PLD6lc2e8uYorDkU0y5qR1s5_M6s4y0pZ9
- Spreadsheet Tips: Vlookup, Arrayformula, Iferror explained - match data from another worksheet ( Download)
- VLOOKUP from Multiple Worksheets (Tabs, Sheets) or Spreadsheets (Files) - Google Sheets ( Download)
- How to Use Array Formula with VLOOKUP in Google Sheets ( Download)
- Arrayformula with VLOOKUP ( Download)
- Google Sheets - Use ARRAYFORMULA Instead of Repeating Functions ( Download)
- Vlookup and Array formula in Google Sheet ( Download)
- How to Extract Data from a Spreadsheet using VLOOKUP, MATCH and INDEX ( Download)
- VLOOKUP into another Workbook (Google Sheets) ( Download)
- VLOOKUP - Google Sheets, Next Level Lookup Arrays - Advanced ( Download)
- Stop using VLOOKUP in Excel. Switch to INDEX MATCH ( Download)
- Google Sheets: Match() with Arrayformula ( Download)
- VLOOKUP to Another Sheet | Easy Steps| ( Download)
- Excel INDIRECT Function: Lookup Values in Different Sheets / Excel Tabs ( Download)
- 🗄 How to look for values in another table in Excel (INDEX + MATCH formulas) in 2 minutes ( Download)
- XLOOKUP - Return Multiple Columns (Values) in Excel ( Download)
