Vlookup and Match problem

[DocAElstein]

I still see 5 reps not 1000

I have to wait until if I have the power to do it, that is why I owe you them ( I.O.U ). Maybe as I am now in debt to you, you must charge me interest on them? - , like 10% every month from now on? So like in November I O U 1100 reps and then December I O U 1200 reps and so on.

---

..
{"Part",13,25,37,48,73,101,145,201,2 89,600,750,1009;"DMG1",4.1,2.85,2.85,1.9,.... with index for DMG1 = 14 (in range lookup)
MATCH is a column index
too many indexes but I'm an old idiot and mixed indexes...

I think I see what you are saying its like “the 14th thing along” , like in if it was in a 1 dimensional or 1 “row” array,
This sort of thing
_number along{1 _ , 2 , 3 , 4 , 5 , 6 , 7 , 8 _ , 9 _ , 10_, 11_, 12_,13 , 14 __ , 15 , _16}
____INDEX({"Part",13,25,37,48,73,101,145,201,289,600,7 50,1009, "DMG1",4.1,2.85},1,14) = "DMG1"
Or similarly
__number along_____{1 _ , 2 , 3 , 4 , 5 , 6 , 7 , 8 _ , 9 _ , 10_, 11_, 12_,13 , 14 __ , 15 , _16}
__=MATCH("DMG1",{"Part",13,25,37,48,73,101,145,201,289,600,750,10 09, "DMG1",4.1,2.85},0) = 14
(Note I must change the row separating ; before the "DMG1" to a column separating , **

I also get indexes mixed up and also I mix up item numbers and indexes. Sometimes they are the same, sometimes they have a similar meaning



( ** just passing interest, if in a range we talk about the “number along” on any range, then we are talking about the range item number, and this “number along” goes like all columns in a row, then next row and so on.
So example in these 3 ranges, the range item number is 14

Row\Col	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Part	13	25	37	48	73	101	145	201	289	600	750	1009	DMG1

Range("A1:N1").Item(14) = "DMG1"

Row\Col	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Part	13	25	37	48	73	101	145	201	289	600	750	1009
2	DMG1	$ 4.10	$ 2.85	$ 2.85	$ 1.90	$ 1.55	$ 1.35	$ 1.25	$ 0.95	$ 0.85	$ 0.75	$ 0.75	$ 0.65

Range("A1:M2").Item(14) = "DMG1"

Row\Col	O	P	Q	R	S	T	U	V	W
4	Part	13	25	37	48	73	101	145	201
5	289	600	750	1009	DMG1	$ 4.10	$ 2.85	$ 2.85	$ 1.90

Range("O4:W5").Item(14) = "DMG1"

Here is a very interesting article by a very clever person on all that https://excelfox.com/forum/showthrea...column-looping )

---

...anyway problem is solved by last argument 0 (-1, 1) ...

For Match is, I think, last argument 0 or 1 or -1
but for VLookUp, last argument is 0 or 1 ( or False or True )