IU Only

Spreadsheets: Using VLOOKUP to find data Asset List

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: Fri Feb 05 16:30:38 EST 2021
    • Last Published By: tlmason
  • 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: Fri Feb 05 16:30:38 EST 2021
      • Last Published By: tlmason
    • 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: Fri Feb 05 16:30:38 EST 2021
        • Last Published By: tlmason
      • Linked From:

        Learn how to enter the VLOOKUP function using references from other worksheets.

        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 May 12 12:15:20 EDT 2021
          • Last Published By: allaw
        • Linked From:

          Explore using absolute cell references in a VLOOKUP function.

          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: Fri Feb 05 16:30:38 EST 2021
            • Last Published By: tlmason
          • 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: Fri Feb 05 16:30:38 EST 2021
              • Last Published By: tlmason
            • 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

              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: Fri Feb 05 16:30:38 EST 2021
                • Last Published By: tlmason
              • 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: Fri Feb 05 16:30:38 EST 2021
                  • Last Published By: tlmason
                • 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: Fri Feb 05 16:30:38 EST 2021
                    • Last Published By: tlmason
                  • Linked From:

                    Learn how to enter the VLOOKUP function using references from other worksheets.

                    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 May 12 12:15:20 EDT 2021
                      • Last Published By: allaw
                    • Linked From:

                      Explore using absolute cell references in a VLOOKUP function.

                      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: Fri Feb 05 16:30:38 EST 2021
                        • Last Published By: tlmason
                      • 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: Fri Feb 05 16:30:38 EST 2021
                          • Last Published By: tlmason
                        • Linked From:

                          Spreadsheets: Using VLOOKUP to find data: : 2 total

                          Spreadsheets: Using VLOOKUP to find data: Files: 0 total