Excel Tutorial - Using VLOOKUP with large tables

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