Specifying the array in Index formula
In the lecture when specifying the array for the Index formula you used a single column. In the Exercise you used the entire table. Why?? Whats the difference between the two?
Hi abhinav!
Thanks for reaching out.
Please pause the video at 1:38. You will see that the INDEX() function works both with an array, as well as a column reference. Whichever option we choose to use, we need to provide a row number afterwards to indicate to Excel which row from the selection we are interested in. Therefore, in the lecture/exercise we opt for a different data subset to work with.
Hope this helps.
Best,
Martin
What's the shortcut you use at 6:19 to update the values in the table?
Hi Stefani!
Thanks for reaching out. Please accept my apologies for the delayed response.
It's a mere Ctrl + V, i.e. Paste combination. It allows us to paste the formula from J4, while preserving its row and column references (fixed through $ before the column letter or the row number).
Hope this helps but please feel free to get back to us should you need further clarification. Thank you.
Kind regards,
Martin
Submit an answer
