Excel Video 362 Using Arrays with SMALL, Part 3 from excel vlookup two cells 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: Excel Video 362 takes our SMALL functionality to the next level by adding two more functions to the mix.If VLOOKUP is new to you, it might help to watch the VLOOKUP playlist starting with Excel Video 61.If you aren’t familiar with WEEKDAY, watch Excel Video 165.We’ll use WEEKDAY to calculate the date of the week in column B and VLOOKUP to look up a matching number for the day of the week we enter in cell F22.If those numbers match and the appointment type and location match, the arra
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!)