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?

Hi Angela, 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! Best, Ned

Follow this topic

Angela Zhang

Last answered:

27 Feb 2023

Posted on:

26 Feb 2023

Resolved: Differences between $B5, B$5, and $B$5?

in Introduction to Excel / Using Index & Match as a Substitute for Vlookup

2 answers ( 1 marked as helpful)

Ned Krastev

Instructor

Posted on:

27 Feb 2023

Helpful answer

Angela Zhang

Posted on:

27 Feb 2023

Resolved: Differences between $B5, B$5, and $B$5?

Submit an answer

related questions