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