Excel Tutorial - Using VLOOKUP with large tables

#Excel
#HowTo
#LinkedIn

[denniskondratiuk]

The best explanation of mass vlookup i found yet. Thanks.

[zhaozhang]

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!

[hardysingh]

Your video solved my problem to select whole table. Thanks

[pencilbender]

all i can find is ways to find a single awnser, is there a way to find a bunch of data by checking a box for a condition?
example: checkbox is linked to C3, _if C3 = TRUE_ i need a list to pop up to a bunch of cells below or next to it.

[vikramraghuwanshi]

Leany a lot's of things from uor vedios.

[hanzadebeyza]

why he did not swrite true or false i am confused

[calebhansen]

how would you do the inverse of this? looking up the outside values with a tax rate?

[shrishtijain]

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.

[estevanlucio]

Alternatively you could use a match function instead the +2

[suyashGx]

C2+2....someone please explain the logic for this

[stoneyja]

How come he didn't use True/False?

[matthewdent]

Hey im doing some VLOOKUP and this is my current task, "Do vlookup of Invoice account with customer Name and repame from Customer Tab" since it is in a seperate window do you know how i would reference the column, since no matter what i edit i always get the #N/A error

[santiandres]

there was no need to finish it with 0, 1, true or false?

[JNCressey]

It's not that big, excel didn't even crash.