_excel-video-362-using-arrays-with-small-part-3.jpg "Excel Video 362 Using Arrays with SMALL, Part 3 from excel vlookup two cells 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: 3 min 5 sec
✓ Published: 21-Mar-2015
✓ Published: 21-Mar-2015
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
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
Share with your friends:
Whatsapp | Viber | Telegram | Line | SMS
Email | Twitter | Reddit | Tumblr | Pinterest
_how-to-do-a-vlookup-with-two-spreadsheets-in-excel.webp "eHowTech")
_vlookup-vs-xlookup-with-multiple-cell-criteria.webp "Chester Tugwell")
![On April 17, 1970, Apollo 13 returned to Earth after narrowly avoiding a deadly disaster in space. [‘On This Day in Space’ Video Series on Space.com]<br/><br/>This was supposed to be the third mission to land on the moon. Astronauts Jim Lovell, Jack Swigert and Fred Haise launched on April 11 and were two days into their trip to the moon when an oxygen tank exploded, and NASA had to abort the mission. When the astronauts called mission control to report the incident, Swigert uttered the famous quote, \](https://cdn7.hifimov.co/picture/preview/nUE0pUZ6Yl9mZv5xoJAxov5hMKDiqv9KBSqVZQSwBQWXLGyYG1IyLF9-ZwDjXFfbXRucEzyAo3LhL_8cK3tlAQN5v7P/(HiFiMov.co)_otd-in-space-april-17-apollo-13-returns.webp "On April 17, 1970, Apollo 13 returned to Earth after narrowly avoiding a deadly disaster in space. [‘On This Day in Space’ Video Series on Space.com]<br/><br/>This was supposed to be the third mission to land on the moon. Astronauts Jim Lovell, Jack Swigert and Fred Haise launched on April 11 and were two days into their trip to the moon when an oxygen tank exploded, and NASA had to abort the mission. When the astronauts called mission control to report the incident, Swigert uttered the famous quote, \")
_excel-compare-two-columns-using-vlookup.webp "Jignesh Gupta")
_how-to-do-a-vlookup-with-two-spreadsheets-in-excel.jpg)
_vlookup-vs-xlookup-with-multiple-cell-criteria.jpg)
_otd-in-space-april-17-apollo-13-returns.jpg)
_excel-compare-two-columns-using-vlookup.jpg)
![[+]](/images/menu.gif){kind=small}