Resolved: Differences between $B5, B$5, and $B$5?
In 2:56, why you put B$5 for the array, but $B61 for the match lookup value and $G$5 for the second range?
Good to hear from you.
Fixing cell references is tricky at first, but then it becomes much easier over time.
So, we have to fix the column reference $B5 whenever we want to paste to the right. In this way column B will stay fixed.
Instead, we want to fix the row reference B$5 (basically we do that by adding the dollar sign in front of the row reference) whenever we will paste downwards and want to keep the cell in row 5.
And lastly, we anchor both references with a dollar sign whenever we want to keep the reference to B5 whenever we paste to the right or downwards.
Hope this helps!