Комментарии:
how would you do the inverse of this? looking up the outside values with a tax rate?
ОтветитьLeany a lot's of things from uor vedios.
ОтветитьYour video solved my problem to select whole table. Thanks
ОтветитьHello, if I am given the table on the left hand side and I have to create the table given on the right hand side, how can I do that?
Like I am given Salary in column and I am given Dep in row and then I have to fill all the values by looking at the table given on the left side.
It's not that big, excel didn't even crash.
ОтветитьAlternatively you could use a match function instead the +2
ОтветитьNew thing i learned in vlookup today
ОтветитьHow come he didn't use True/False?
ОтветитьThis vid is brilliant. I would've come up with a super complicated IF formula to tackle this problem: IF(DEP=0, VLOOKUP(),DEP=1,VLOOKUP(),...,VLOOKUP()). This vid simplifies it big time. Thank you very much for sharing!
ОтветитьC2+2....someone please explain the logic for this
ОтветитьBrilliant
ОтветитьThe best explanation of mass vlookup i found yet. Thanks.
Ответитьthere was no need to finish it with 0,1, true or false?
Ответитьamazing thanks alot
Ответить