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?

New contributor
carljong2019 is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
  • It's hard to tell what problem you're encountering and why from the question. If the lookup table is a range of cells, you don't need an array formula, just Enter. – fixer1234 Aug 13 at 4:52

Your Answer

carljong2019 is a new contributor. Be nice, and check out our Code of Conduct.

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.