_excel-video-176-row-with-hlookup.jpg "Excel Video 176 ROW with HLOOKUP from how to use hlookup Video Screenshot Preview")
GalleryPlay Video:
(Note: The default playback of the video is HD VERSION. If your browser is buffering the video slowly, please play the REGULAR MP4 VERSION or Open The Video below for better experience. Thank you!)
⏲ Duration: 2 min 0 sec
✓ Published: 21-Mar-2015
✓ Published: 21-Mar-2015
Description:
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
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
Share with your friends:
Whatsapp | Viber | Telegram | Line | SMS
Email | Twitter | Reddit | Tumblr | Pinterest
Related Videos
_the-ultimate-xlookup-tutorial-the-best-excel-formula.webp "Kenji Explains")
_advanced-excel-tutorial.webp "Learn how to master various functions in Excel. Learn how to automate advanced calculations using various functions.nLearn how to use the following functions in Excel:nSumnSumIFnSumIF'snSumProductnVLookUpnHLookUpnIndexnDatavalidation and more")
_how-to-use-vlookup-to-compare-two-lists.webp "Simon Sez IT")
_7-essential-habits-of-vlookup-pros.webp "Excel Campus - Jon")
_how-to-use-lookup-functions-in-excel-vlookup-index-and-match-and-xlookup-training-tutorial.webp "Simon Sez IT")
⏲ 1 hour 1 minute 36 seconds 👁 3K
_xlookup-in-excel-explained-in-3-minutes.webp "Excel Campus - Jon")
_how-to-access-chatgpt-beginners-guide.webp "Wondering how to use the AI system ChatGPT? We'll show you")
_master-pivot-tables-in-10-minutes-using-real-examples.webp "Kenji Explains")
_the-ultimate-xlookup-tutorial-the-best-excel-formula.jpg)
_advanced-excel-tutorial.jpg)
_how-to-use-vlookup-to-compare-two-lists.jpg)
_7-essential-habits-of-vlookup-pros.jpg)
_how-to-use-lookup-functions-in-excel-vlookup-index-and-match-and-xlookup-training-tutorial.jpg)
_xlookup-in-excel-explained-in-3-minutes.jpg)
_how-to-access-chatgpt-beginners-guide.jpg)
_master-pivot-tables-in-10-minutes-using-real-examples.jpg)
![[+]](/images/menu.gif){kind=small}