Vlookup and Match problem

[DocAElstein]

with formula =VLOOKUP(F$26,bk,MATCH($B$24,bkt,1)+1,0) value $1.55 is returned and so on
..just forgot comma on the end or define last argument 0, VLOOKUP(F$26,bk,MATCH($B$24,bkt,1)+1,) so he need to learn how to use VLOOKUP function
VLOOKUP require all arguments, even if last argument is omitted there should be defined place for it after last comma

https://i.postimg.cc/15VpN7Hj/ThatsIt.jpg
( I thought I had checked that, but missed something somewhere, I don’t know why I missed that, maybe I think also I need to learn how to use VLoopUp properly! )

---

---

But just out of interests, and for me to learn better, 2 things you said I don’t understand……

_1

where is DMG1 on index = 6 ?

Why you say this? DMG1 is LookUp_Value so is in column A ( index 1 )
What am I missing again?

_2

I see DMG1 on index = 14

Why you say this? There is no index 14? Index 14 would be column N, but column N is not in range A1:M13 ( maximum column_index for table_array range A1:M13 is 13 )
What am I missing again?


Can you help me understand what I am missing, Thx

( I also do not understand why it works sometimes? )