Spreadsheets: Using VLOOKUP to find data Asset List
- Current folder path within the WCMS: /training/vlkup/files/pc
- Title Code: vlkup
- Title Description Page: https://ittraining.iu.edu/explore-topics/titles/vlkup
- Expand Course URL: https://expand.iu.edu/browse/ittraining/single/courses/vlkup
Expand the accordions to see the lists of assets and their properties.
Spreadsheets: Using VLOOKUP to find data: Pages: 9 total
Explore the VLOOKUP function in both Microsoft Excel and Google Sheets.
- Asset Path: /training/vlkup/files/pc/introducing-vlookup
- Asset Link: site://IU-UITS-ITTRAIN.content/training/vlkup/files/pc/introducing-vlookup
- Asset System Name: introducing-vlookup
- Asset Data Definition: Page - Content Blob
- Last modified by: allaw
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
- Linked From:
Use the VLOOKUP function to find an exact match.
- Asset Path: /training/vlkup/files/pc/vlookup-exact-match
- Asset Link: site://IU-UITS-ITTRAIN.content/training/vlkup/files/pc/vlookup-exact-match
- Asset System Name: vlookup-exact-match
- Asset Data Definition: Page - Content Blob
- Last modified by: allaw
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
- Linked From:
See how to use more than one VLOOKUP function in a worksheet.
- Asset Path: /training/vlkup/files/pc/vlookup-multiple
- Asset Link: site://IU-UITS-ITTRAIN.content/training/vlkup/files/pc/vlookup-multiple
- Asset System Name: vlookup-multiple
- Asset Data Definition: Page - Content Blob
- Last modified by: allaw
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
- Linked From:
Learn how to enter the VLOOKUP function using references from other worksheets.
- Asset Path: /training/vlkup/files/pc/vlookup-across-worksheets
- Asset Link: site://IU-UITS-ITTRAIN.content/training/vlkup/files/pc/vlookup-across-worksheets
- Asset System Name: vlookup-across-worksheets
- Asset Data Definition: Page - Content Blob
- Last modified by: allaw
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
- Linked From:
See how to use the VLOOKUP function to find an approximate, or closest without going over, match.
- Asset Path: /training/vlkup/files/pc/vlookup-approx-match
- Asset Link: site://IU-UITS-ITTRAIN.content/training/vlkup/files/pc/vlookup-approx-match
- Asset System Name: vlookup-approx-match
- Asset Data Definition: Page - Content Blob
- Last modified by: allaw
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
- Linked From:
Explore using absolute cell references in a VLOOKUP function.
- Asset Path: /training/vlkup/files/pc/vlookup-absolute-references
- Asset Link: site://IU-UITS-ITTRAIN.content/training/vlkup/files/pc/vlookup-absolute-references
- Asset System Name: vlookup-absolute-references
- Asset Data Definition: Page - Content Blob
- Last modified by: allaw
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
- Linked From:
See how to use a named range in a VLOOKUP function.
- Asset Path: /training/vlkup/files/pc/vlookup-named-ranges
- Asset Link: site://IU-UITS-ITTRAIN.content/training/vlkup/files/pc/vlookup-named-ranges
- Asset System Name: vlookup-named-ranges
- Asset Data Definition: Page - Content Blob
- Last modified by: allaw
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
- Linked From:
Practice your VLOOKUP skills with additional exercise files.
- Asset Path: /training/vlkup/files/pc/vlookup-additional
- Asset Link: site://IU-UITS-ITTRAIN.content/training/vlkup/files/pc/vlookup-additional
- Asset System Name: vlookup-additional
- Asset Data Definition: Page - Content Blob
- Last modified by: allaw
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
- Linked From:
Spreadsheets: Using VLOOKUP to find data: : 2 total
Spreadsheets: Using VLOOKUP to find data: Files: 0 total
Spreadsheets: Using VLOOKUP to find data Asset List
- Current folder path within the WCMS: /training/vlkup/files/pc
- Title Code: vlkup
- Title Description Page: https://ittraining.iu.edu/explore-topics/titles/vlkup
- Expand Course URL: https://expand.iu.edu/browse/ittraining/single/courses/vlkup
Expand the accordions to see the lists of assets and their properties.
Spreadsheets: Using VLOOKUP to find data: Pages: 9 total
Explore the VLOOKUP function in both Microsoft Excel and Google Sheets.
- Asset Path: /training/vlkup/files/pc/introducing-vlookup
- Asset Link: site://IU-UITS-ITTRAIN.content/training/vlkup/files/pc/introducing-vlookup
- Asset System Name: introducing-vlookup
- Asset Data Definition: Page - Content Blob
- Last modified by: allaw
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
- Linked From:
Use the VLOOKUP function to find an exact match.
- Asset Path: /training/vlkup/files/pc/vlookup-exact-match
- Asset Link: site://IU-UITS-ITTRAIN.content/training/vlkup/files/pc/vlookup-exact-match
- Asset System Name: vlookup-exact-match
- Asset Data Definition: Page - Content Blob
- Last modified by: allaw
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
- Linked From:
See how to use more than one VLOOKUP function in a worksheet.
- Asset Path: /training/vlkup/files/pc/vlookup-multiple
- Asset Link: site://IU-UITS-ITTRAIN.content/training/vlkup/files/pc/vlookup-multiple
- Asset System Name: vlookup-multiple
- Asset Data Definition: Page - Content Blob
- Last modified by: allaw
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
- Linked From:
Learn how to enter the VLOOKUP function using references from other worksheets.
- Asset Path: /training/vlkup/files/pc/vlookup-across-worksheets
- Asset Link: site://IU-UITS-ITTRAIN.content/training/vlkup/files/pc/vlookup-across-worksheets
- Asset System Name: vlookup-across-worksheets
- Asset Data Definition: Page - Content Blob
- Last modified by: allaw
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
- Linked From:
See how to use the VLOOKUP function to find an approximate, or closest without going over, match.
- Asset Path: /training/vlkup/files/pc/vlookup-approx-match
- Asset Link: site://IU-UITS-ITTRAIN.content/training/vlkup/files/pc/vlookup-approx-match
- Asset System Name: vlookup-approx-match
- Asset Data Definition: Page - Content Blob
- Last modified by: allaw
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
- Linked From:
Explore using absolute cell references in a VLOOKUP function.
- Asset Path: /training/vlkup/files/pc/vlookup-absolute-references
- Asset Link: site://IU-UITS-ITTRAIN.content/training/vlkup/files/pc/vlookup-absolute-references
- Asset System Name: vlookup-absolute-references
- Asset Data Definition: Page - Content Blob
- Last modified by: allaw
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
- Linked From:
See how to use a named range in a VLOOKUP function.
- Asset Path: /training/vlkup/files/pc/vlookup-named-ranges
- Asset Link: site://IU-UITS-ITTRAIN.content/training/vlkup/files/pc/vlookup-named-ranges
- Asset System Name: vlookup-named-ranges
- Asset Data Definition: Page - Content Blob
- Last modified by: allaw
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
- Linked From:
Practice your VLOOKUP skills with additional exercise files.
- Asset Path: /training/vlkup/files/pc/vlookup-additional
- Asset Link: site://IU-UITS-ITTRAIN.content/training/vlkup/files/pc/vlookup-additional
- Asset System Name: vlookup-additional
- Asset Data Definition: Page - Content Blob
- Last modified by: allaw
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Wed Jul 24 17:08:17 EDT 2024
- Last Published By: jloakes
- Linked From: