Did you mean?
Search Results - Showing 12 - 24 Of 39
_excel-video-176-row-with-hlookup.jpg "In Excel Video 174, I explained that one of the gotchas in VLOOKUP is that when you copy a VLOOKUP formula, the column reference doesn’t change.We used an Excel function called COLUMN as the column reference so that we could easily copy the VLOOKUP formulas.In Excel Video 176, I’ll show you a very similar trick for HLOOKUP.nnJust like VLOOKUP, when you copy an HLOOKUP formula, the row reference won’t update as the rest of the cell references do.Today, we’ll use the ROW function to")
⏲ 2 min 0 sec ✓ 21-Mar-2015
_how-to-use-xlookup-in-microsoft-excel.jpg "Kevin Stratvert")
⏲ 13 minutes 39 seconds 👁 86.7K
_excel-tips-don39t-use-formulas-use-ctrl-e-instead.jpg "Career Solutions")
⏲ 2 minutes 53 seconds 👁 409.5K
_excel-video-178-index.jpg "Excel Video 178 introduces INDEX, a more flexible lookup function than VLOOKUP or HLOOKUP.One of the shortcomings of VLOOKUP, for example, is that the data you’re looking for has to be in the far left column of the range you’re looking in.(No, you can’t enter a negative number for column reference to make VLOOKUP look at prior columns.)Combining INDEX with MATCH is a powerful way to look up a variety of information.nnI’ll start Excel Video 178 by showing you a combined INDEX and MA")
⏲ 2 min 24 sec ✓ 21-Mar-2015
_top-10-essential-excel-formulas-for-analysts-in-2024.jpg "Kenji Explains")
⏲ 13 minutes 39 seconds 👁 350.8K
_master-the-if-formula-in-excel-beginner-to-pro.jpg "Kenji Explains")
⏲ 11 minutes 16 seconds 👁 142.4K
_excel-video-179-match.jpg "Watch Excel Video 179 to get started with MATCH, a flexible Excel function that can add power to other functions.The syntax of MATCH is:nn=MATCH(what to look for, where to find it, match type).nnWhat to look for (lookup value) and the range to find it are very similar to VLOOKUP and HLOOKUP.The match type is a little different.Instead of true and false, match type can be 1 (largest value that is less than or equal to the lookup value with the data sorted in ascending order, similar to TRUE")
⏲ 3 min 15 sec ✓ 21-Mar-2015
_the-mistake-almost-every-excel-user-makes-free-file.jpg "MyOnlineTrainingHub")
⏲ 10 minutes 16 seconds 👁 42.7K
_how-to-use-xlookup-across-two-worksheets-124-xlookup-examples-across-two-sheets.jpg "Chester Tugwell")
⏲ 8 minutes 22 seconds 👁 17K
_excel-video-90-get-a-drop-down-box-without-programming.jpg "Excel Video 90 takes a quick break from OFFSET to show you how to create a drop-down box like the one in Excel Video 89.Hopefully you saw the drop-down box I created as part of Excel Video 89 to show the components of the OFFSET function for Year, SanDiego, and LosAngeles.There are three tricks I used in creating the drop-down box.nnFirst, select the cell you want the drop-down box in, then go to the Data tab and choose Data Validation.In the drop down box labeled Allow, choose List.Then")
⏲ 2 min 69 sec ✓ 21-Mar-2015
_how-to-use-vlookup-to-compare-two-lists.jpg "Simon Sez IT")
⏲ 15 minutes 20 seconds 👁 338.8K
_you-won39t-believe-these-crazy-pivot-table-hacks.jpg "Leila Gharani")
⏲ 11 minutes 30 seconds 👁 315.4K
Related Searches
Search Videos
Recent Searches
_excel-video-176-row-with-hlookup.webp "In Excel Video 174, I explained that one of the gotchas in VLOOKUP is that when you copy a VLOOKUP formula, the column reference doesn’t change.We used an Excel function called COLUMN as the column reference so that we could easily copy the VLOOKUP formulas.In Excel Video 176, I’ll show you a very similar trick for HLOOKUP.nnJust like VLOOKUP, when you copy an HLOOKUP formula, the row reference won’t update as the rest of the cell references do.Today, we’ll use the ROW function to")
_how-to-use-xlookup-in-microsoft-excel.webp "Kevin Stratvert")
_excel-tips-don39t-use-formulas-use-ctrl-e-instead.webp "Career Solutions")
_excel-video-178-index.webp "Excel Video 178 introduces INDEX, a more flexible lookup function than VLOOKUP or HLOOKUP.One of the shortcomings of VLOOKUP, for example, is that the data you’re looking for has to be in the far left column of the range you’re looking in.(No, you can’t enter a negative number for column reference to make VLOOKUP look at prior columns.)Combining INDEX with MATCH is a powerful way to look up a variety of information.nnI’ll start Excel Video 178 by showing you a combined INDEX and MA")
_top-10-essential-excel-formulas-for-analysts-in-2024.webp "Kenji Explains")
_master-the-if-formula-in-excel-beginner-to-pro.webp "Kenji Explains")
_excel-video-179-match.webp "Watch Excel Video 179 to get started with MATCH, a flexible Excel function that can add power to other functions.The syntax of MATCH is:nn=MATCH(what to look for, where to find it, match type).nnWhat to look for (lookup value) and the range to find it are very similar to VLOOKUP and HLOOKUP.The match type is a little different.Instead of true and false, match type can be 1 (largest value that is less than or equal to the lookup value with the data sorted in ascending order, similar to TRUE")
_the-mistake-almost-every-excel-user-makes-free-file.webp "MyOnlineTrainingHub")
_how-to-use-xlookup-across-two-worksheets-124-xlookup-examples-across-two-sheets.webp "Chester Tugwell")
_excel-video-90-get-a-drop-down-box-without-programming.webp "Excel Video 90 takes a quick break from OFFSET to show you how to create a drop-down box like the one in Excel Video 89.Hopefully you saw the drop-down box I created as part of Excel Video 89 to show the components of the OFFSET function for Year, SanDiego, and LosAngeles.There are three tricks I used in creating the drop-down box.nnFirst, select the cell you want the drop-down box in, then go to the Data tab and choose Data Validation.In the drop down box labeled Allow, choose List.Then")
_how-to-use-vlookup-to-compare-two-lists.webp "Simon Sez IT")
_you-won39t-believe-these-crazy-pivot-table-hacks.webp "Leila Gharani")
![[+]](/images/menu.gif){kind=small}