Excel Video 174 COLUMN with VLOOKUP from hlookup formula in excel Watch Video
Preview(s):
Gallery
Play 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!)
Description: VLOOKUP’s a great function, but when you try to copy a VLOOKUP formula, watch out for a gotcha you’ll see in Excel Video 174.When you copy most formulas in Excel, Excel updates the references as you copy.That’s not true with VLOOKUP.When you copy a VLOOKUP formula, the column reference (2 in the video) stays the same.nnIf you have a VLOOKUP formula you’re going to copy a lot, try using COLUMN.COLUMN is a very simple function that simply returns what column number you’re in.Wh
Play 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!)