0th question: If I write “=VLOOKUP($B3;Items;J$71)+…+VLOOKUP($G3;Items;J$71)” it does the correct thing. As I understand the single value CSE is supposed to work in these cases as

“{=VLOOKUP($B3:$G3;Items;J$71)}” (obviously entered without curly brackets and pressing ctrl+shift+enter. For me, it only works in the singular case when the value is found in the first row by vlookup. What am I doing wrong?

The question itself, after the 0th case works:

Say, the result of the previous goes into the cell J1. Now I would like the same for J1:V1 with the last argument of vlookup being J71:V71 respectively. If I select the whole J1:V1 interval and enter {=VLOOKUP($B3:$G3;Items;J$71:V$71)} the same way it should work right? Unfortunately neither works for me and I am kinda lost.

ps: ignore or correct $ marks, I think they are not the source of my problem.

ps2: Items is a table I made and excel likes to move around the columns, which I hardly ever want, so I tried with absolute range reference instead as well. Didn’t solve the problem. (1: how to do absolute reference with a table?)

I dare ask a completely unrelated side question, for which the answer I couldn’t manage to find anywhere. Found similar issues with suggestions, none solved mine. (2: A lot of functions seem to be missing for me. One day they were there and I could use them, and the other day Excel just decided that those functions simply do not exist. Previously written formulae didn’t work, it wouldn’t suggest the formula as auto complete and so on. XLOOKUP and FILTER were 2 I noticed, but I am convinced they are not the only ones)

Thank you very much for your answer! Extra special thanks if I can get answers for my 2 extra questions, too! Have a nice day!

​0th question: If I write “=VLOOKUP($B3;Items;J$71)+…+VLOOKUP($G3;Items;J$71)” it does the correct thing. As I understand the single value CSE is supposed to work in these cases as”{=VLOOKUP($B3:$G3;Items;J$71)}” (obviously entered without curly brackets and pressing ctrl+shift+enter. For me, it only works in the singular case when the value is found in the first row by vlookup. What am I doing wrong? The question itself, after the 0th case works:Say, the result of the previous goes into the cell J1. Now I would like the same for J1:V1 with the last argument of vlookup being J71:V71 respectively. If I select the whole J1:V1 interval and enter {=VLOOKUP($B3:$G3;Items;J$71:V$71)} the same way it should work right? Unfortunately neither works for me and I am kinda lost. ps: ignore or correct $ marks, I think they are not the source of my problem.ps2: Items is a table I made and excel likes to move around the columns, which I hardly ever want, so I tried with absolute range reference instead as well. Didn’t solve the problem. (1: how to do absolute reference with a table?) I dare ask a completely unrelated side question, for which the answer I couldn’t manage to find anywhere. Found similar issues with suggestions, none solved mine. (2: A lot of functions seem to be missing for me. One day they were there and I could use them, and the other day Excel just decided that those functions simply do not exist. Previously written formulae didn’t work, it wouldn’t suggest the formula as auto complete and so on. XLOOKUP and FILTER were 2 I noticed, but I am convinced they are not the only ones) Thank you very much for your answer! Extra special thanks if I can get answers for my 2 extra questions, too! Have a nice day!  Read More

​