Question about VLOOKUP (in Dutch VERT.ZOEKEN)
The result of “VERT.ZOEKEN(F1;A:B;2;0)” is 113, that is correct.
Then I insert another column.
VERT.ZOEKEN(F1;A:B;2;0) changes to VERT.ZOEKEN(G1;A:C;2;0).
The changes (F1 to G1) and (A:B to A:C) I can understand.
My question: Why doesn’t change the column number “2” change to “3”?
(See attachment for screenprints)
|