Excel 2010 INDEX and MATCH functions nested

Toggle fullscreen Fullscreen button

Sharing buttons:

hey everybody this video is the fourth

in a series of six about some of the

more complicated things you can do while

calculating information in Microsoft

Excel more specifically I got an email

recently where the solution to the

problem that was presented to me was

rather complex it involved nested

functions and array functions and the

idea here is that nested functions

combine multiple functions together in

order to solve a problem and array

functions allow you to sequentially move

down a list and calculate over and over

again so we've already addressed Rijn

ested functions with the round function

with the if error function and also with

the if and and functions together if

you'd like to go back and watch those

videos again feel free to click the

links that are on the screen now and