This question is related to this one: VLOOKUP - return multiple values/columns for one row/match of data
Let's say you have a column of values that you want to use as lookup values. I referenced the first value in the column in my vlookup formula. But, when I hit Ctrl+Shift+Enter, each row used the value from the first cell instead of adjusting the reference for the formula below. The reference value, the first value in the vlookup formula, was fixed although I did not use an absolute address.
How can you have the formula adjust when it fills the highlighted area?