Welcome to Excel

basics video number 14. In this video, we got to talk

about the amazing Excel VLOOKUP function. And it is going to be amazing. We have nine examples. Now just to start off, last

video we did the IF function. And this is what

we want to avoid. We do not ever want to

have to do an IF where we have to check multiple items. So last video, we did IF

to put one of two things into the cell. In this video, we’ll get to

see the VLOOKUP function. Such simplicity, such an

important function in business. And VLOOKUP will

be what we will use any time we have three or

more items to put into a cell. Now, here are the amazing

topics we have in this video. And before we go look at

each one of those example, let’s go look at what

we did last video and we’ll compare

it to what we’re going to do in this video. So, I’m going to click on

the sheet IF or VLOOKUP. So F2, this is what

we did last video. We checked a particular

sales number. We had a test, we

asked the question is it greater than or equal

to and our hurdle was 20,000. Then, we put one of two

things into the cell. But this video, we want

to see how to do this, but not with the IF function. Notice the IF

function has to check every one of these conditions. And in business, this is

oftentimes the way commissions work. You get a larger

bonus commission as your sales increase. So we’re going to go from that

formula down to this formula right here. And VLOOKUP will return

exactly the same percentage to every single cell, without

having to do that huge, long IF function. Now fundamentally, what

does VLOOKUP function do? Well, VLOOKUP is looking up

a sales number in a bonus commission lookup table and

returning one of the bonus percentages back to the cell. So VLOOKUP looked

up a sales number and returned

something to the cell. In this case, it returned 1%. Now this is a

commission example. There’s lots of other

amazing examples down here. If I hit F2, VLOOKUP

is looking up a product name in a

product price lookup table and going to get

the right price. And then, what is VLOOKUP do? It brings that price

back to the cell. So both of these

examples, and many others, we’ll see in this video. Now, both of these tables

are called lookup tables. And the reason that VLOOKUP

is so important and so common is because, if we go over to

the sheet, lookup is everywhere. Lookup is everywhere. Now, what is the price for quad? If I asked you to look in

that table, well of course, you would realize

that it’s quad, race through the first

column, find a match, and then jump over to the third

column, which is the price, and then you would

say it’s $43.95. In the next example down here,

if your sales are $36,500 and I asked what commission

bonus percentage did you earn, well, you’d look up the

$36,500 in the first column of the lookup table. When you found the

right row, you’d jump over to the third column. And your commission

percentage would be 4%. In our third lookup

table example, if I asked you what Hal

Chuck’s zip code was, well, you’d look up Hal

Chuck’s in the first column of the lookup table. When you found the right row,

you’d jump over– one, two, three, four– to the fifth column,

and get the zip code. Down here, if your

income is $3,000 and I asked you

what your tax is, well, you’d look up the

$3,000 in the first column of the lookup table. And when you found

the right row, you’d jump over to the one– second column to

get the tax of $60. Down here, in this

lookup table, if I asked what region does

Josephina Miles represent, well, you’d look up Josephina

Miles in the first column of the lookup table. When you found the

right row, you’d go one, two, into the

second column and you’d say, well, she’s in the

Southwest region. Still another

example, if your sales are $6,000 what is

your commission rate? Well you look up the $6,000 in

the first column of the lookup table, find the right row,

jump over, in this case, to the second column, and

your commission amount would be $200. And then our final

lookup table example, if your sales are $375, what

is the category assigned to that sales amount. Well, you would look up the

$375 in the first column of the lookup table,

find the right category, jump over one, two,

to the third column, and that would be the category. Every single one of

these lookup tables, we’re always looking

something up, finding a match in the first

column, and jumping over to one of the columns– two, three, four, five,

whichever number column it is– and getting something–

that $43.95– and bringing it back– in our case, we’ll be bringing

it back to a cell or a formula. Lookup tables are everywhere. Now one last thing, before we

go to look at examples 1 and 2. Notice that all the items

are listed vertically in every single one

of these tables. The vast majority of

lookup tables are vertical. That’s why they call it

V for vertical, VLOOKUP. All right, let’s go

over to the sheet V1 2 and look at our first example. Now actually, on this sheet

I have a bunch of notes up at the top here about

what we’re going to do. Those are also over

in the PDF notes. Now in our first

1 and 2 examples, we have a product

price lookup table. In the first column, we have

the name of the product. In the second column, we

have the supplier name. And in the third column,

we have the price. And our goal in

this cell is to have VLOOKUP look up the product

name and return the price. Down here, we’ll do the

same type of formula using this lookup

table, but we’ll look up the price for

each one of the products in this invoice. All right, this will be the

first time we’ve seen VLOOKUP. I’m going to type an

equal sign and then VL. Once you type VL,

VLOOKUP will always show up in blue from the

function dropdown list, so you can hit Tab. Now, there’s one, two, three,

four arguments in VLOOKUP. And we’ll go through each

one of them one at a time. Now, lookup value– that simply

is the item that you want to look up and try and find

a match in the first column of the lookup table. So just like we have to

know what to go and look up, so does VLOOKUP. That’s lookup value. Now we type a comma to

get to the next argument. And this argument

says, table array. Now, I always remember what

to put into this argument because as soon

as it says table, I know I need to give

it the whole table. Now I wish that they

called this lookup table instead of table array. So I’m going to

highlight the table. And you do not need the

field names at the top like you do for a pivot table. You only need the items to match

in the first column and then, any subsequent columns of items

you potentially want to get, and retrieve, and

bring back to the cell. So we put in the whole table,

including the items to match and the items to

potentially look up. All right, now I type a comma. Column index number. Now, column index number– if we’re looking

up this product, we know to look up at the

top and say, OK, price is what I need. But VLOOKUP has no idea

which one of those columns has the item that it needs

to go and get, and bring back to the cell. Now, I always remember what

goes into this argument because it says col

and col is for column. So column index number. And this is counting

on your fingers. Wherever your table is,

you always count 1, 2, 3. Since we want price,

that’s the third column. So, I just type a three

into column index number. Now, VLOOKUP knows

to always go and get whatever is in the third column. Now, comma. The fourth argument is

called range lookup. And VLOOKUP can actually

do two types of lookup. Approximate match

lookup– that’s like the commission lookup. Exact match lookup– that’s

like what we’re doing. We’re looking up exactly Q-U-A-D

and trying to find a match in the first column. Now, true and false– I’m not quite sure why

they use true and false– but if you select

true, then VLOOKUP knows to do approximate

match lookup. If you select false, it knows

to do exact match lookup. Now technically, the way

this argument works– if you put false,

or a zero, then it knows to do exact match. Now, I’m going to

Backspace for a second and type that comma again. The reason they

have this dropdown is to make it easy for people. So if you want to just double

click it, boom, that will work. False now tells VLOOKUP

to find exactly quad. I like to type a zero,

so I type a zero. You’re welcome to

do it either way. So you could put false or zero. And that’s it. Our four arguments. Close parentheses and Enter. That is so cool. Now, I’m going to click

over here and type V Rang. And when I hit

Enter, instantly, it looks up the right

price for V Rang. Now that was our first example

of doing exact match VLOOKUP to get a product price. I want to do the

same exact formula, but I want to do it down

here in our invoice. And notice, we’re going

to look up the product. And as I copy the

formula down, I’m always looking up

the product, trying to get the price from

the third column. So we’re going to do the

VLOOKUP function again. Equals VL. I see VLOOKUP in blue in

the dropdown, so I hit Tab. The lookup value, I’m

going to use my arrow key. So for this invoice,

as I copy it down, the product name will always

be two cells to my left, as a relative cell reference. Comma, table array. It says table, so I know I

need to put the whole table without the field names– the first column and

all the other columns. Now I’m copying

this formula, so I want to make sure and hit

the F4 key to lock it. Now, comma, column index number. VLOOKUP needs to know which

one of the columns– one, two, or three– has the price. Since price is in the third

column, I simply type a three. Comma. Since we’re doing

exact match, I want to look up exactly Flying Eagle. You either put false or zero. Close parentheses. Control-Enter and copy it down. That is totally beautiful. Now, I filled out the

rest of the invoice, simply multiplying

quantity and price, and then adding

them up down here. But VLOOKUP is totally

amazing for invoicing. Now, we got to see

a potential problem and then, learn about data

validation dropdown list. I’m going to type,

quad and Enter. Uh oh. NA means Not Available. If I hit F2, that means

VLOOKUP tried to look up whatever I put in the cell

there in the first column and since it couldn’t

find it, it was polite. It says, hey, that’s

not available. Now what did I do? What I’ve done so many

times in this class and what we humans do

so many times in Excel– I mistyped. I either spelled it

wrong or in this case, I put an extra space. If I Backspace and hit

Enter, then of course, VLOOKUP knows

exactly what to do. It tried to find

Q-U-A-D. It found it, it went over the third

column, and brought it back. Now instead of

relying on typing, any time you’re doing

exact match lookup and we already have

our lookup table, we can add a dropdown list

that we can select from, from only the items in the first

column of the lookup table. So you ready? We’re going to see

how to do this. We’re going to select cell E23. I’m going to go up to data, over

data tools, and there it is. Data validation. If your screen is very

small, your button might look teeny like that. But however you do it,

select the cell E23, click on data validation. Now, data validation,

settings tab– we want to look at the allow. Now by default, all the cells

in the sheet allow any value. But you click this dropdown

and you can actually do a bunch of cool things. You can have certain whole

numbers, decimals, dates, times, and text length,

but what we want is list. Once we select list, the

source text box pops up and we highlight the first

column of the lookup table. What this is going

to do is this will be our list that will show

up in the cell as a dropdown. Now this dialog box is

called data validation. That means we want to

validate any data that goes into the cell. And that’s what data

validation list will do for us. Now, I’m going to click OK– we’re going to come back to this

dialog box in just a second– and now there’s a dropdown. Look at that. I can select V Rang. Ah, that is so magic. Select Carlota and there it is. Now I’m going to select Quad. Now I want to go back up to

the data validation dialog box. I’m going to click this button. It opens it and

there’s the settings. We can actually add

an input message. If I type something like,

select from dropdown list, and then, I’m going to put a

little message down here also. Select product name

from dropdown list, this will appear every

time we select the cell and tell the user of

the spreadsheet what they need to do. Not only that, but if you

type the wrong value there, we can give them an error alert. I’m going to click

in title, Control-V because I copied

it from over there, and do the same type of message. And so, I typed both a

title and an error message. Now, let’s click OK. And look at that, when I

click over here, nothing. But when I click

here, it totally tells us what we need to do. I’m going to select V Rang. Now, I’m going to try and

type something here that’s not in that list. When I Enter, look at that. That’s our first

personalized pop-up message. Select product name

from dropdown list. I’m going to say retry. I’m going to delete that and

then, select from the list. And there we go. Now, I want to do the same

thing down here for the invoice. So I’m going to highlight

a range of cells, go up to data validation list. I’m not going to add error

alert or input message. You can if you want. Settings, I want to select list. This is so amazing. Source, it’s always the

first column only, just a list of names. Click OK. And now, in each

one of these cells, we have our dropdown list. All right, so that’s

example 1 and 2. In both of these examples,

we did exact match and we also saw data

validation dropdown list. Now, let’s go talk about

approximate match lookup. I’m going to click

on the sheet V 3 4. And what we want to do here

is use approximate match VLOOKUP to get a bonus

commission percentage. Here’s our employees

and our sales. And of course, what

we want to avoid is F2 that long

IF function, that would have to individually

check each one of the conditions in order to get to the

bonus commission percentage and then, return it

back to the cell. Now the amazing thing, when we

use the VLOOKUP function is it will totally be able

to look this up. And even though I can’t

find exactly the 17,382, VLOOKUP will know

exactly what to do. Now 17,382, that would fit

in this category right here. Now how does VLOOKUP know– when it’s looking

up this number, how does it know to go to this

row and fit into this category? Because VLOOKUP

will look this up, race through this first

column, which has to be sorted smallest to biggest– it’ll actually race

through and when it finds the first number

bigger, it jumps back a row. Now VLOOKUP knows any

time it sees 10,000 here and 20,000 in the next

category, it automatically interprets that as, OK, this row

is going to be $10,000 or more, all the way up to, but

not including, 20,000. So that means for every

single one of these rows, VLOOKUP will interpret it

as, well, there’s 30,000– that number is included for

this row, all the way up to, but not including,

the next number. And that just makes our

formula so easy and simple, as compared to our IF function. All right, we’re

going to try this. You ready? Equals VL. I see my VLOOKUP highlighted

in blue, I hit Tab. Lookup value– just like

for our exact match, we have to look something

up and try and find a match in the first column. Now I type a comma, table array. The word, table, in the

name of the argument reminds me that I have to

give VLOOKUP the entire table. We highlight the first

column with the items to match and any other columns. Now, I actually added the

upper and lower limit category just so we could,

as we’re learning, use that to understand

the category for each row. So really, we don’t

need this third column. I’m actually– and notice

the dancing ants are still dancing– I’m going to highlight the first

column and the second column. The second column

has the percentages that I want to go and get,

and bring back to the cell. Now for table array,

I’m copying this, so I need to hit the

F4 key to lock it. Now comma, column index. Remember, C-O-L reminds

us that that’s the column. VLOOKUP needs to know

which one of the columns– one or two– has

the thing that it wants to go and get, and

bring back to the cell. So I counted on my fingers and

I counted the second column as the column with the

bonus percentage commission. So I type a 2. Comma. Now remember, VLOOKUP does

two different types of lookup. Exact match– that’s when

you’re looking up, like, text. Q-U-A-D, like in

our last example. Approximate match–

that’s always, when we have our first

column sorted from smallest to biggest, and it will

race through until it finds the first number bigger– in our case, 20,000– and

know to jump back one row. Now actually, technically,

that is not how it does it. It does something called

a binary search, which is a computer term for how

computers do approximate match lookup. But for our

understanding, think of it as VLOOKUPs racing through until

it sees the first bigger number and jumps back one row. So I’m going to choose

approximate match. Now, look up here. Just like for exact

match, there’s various options to tell

VLOOKUP that you want it to do approximate match. So for approximate

match, you can put true, which means double click. Backspace, Backspace, Backspace. Or you can put a

1, so I can put 1. Or I can leave it omitted. So the default

behavior, if I do not put anything for range

lookup, is approximate match. And what that means is if

I Backspace, Backspace– that means I don’t even put

anything in for that argument. We saw this once

before in our class when we used the PMT

function– the payment function for a loan. If there’s an argument– and arguments that are

listed in square brackets always will mean if

you know that default, you don’t have to put it in. So when we’re doing

approximate match, we’re never going to put it in. Now, I’ll leave it up to you. You can comma, put a true, a

one, or don’t put anything. I’m always going to

not put anything. All right, so we’re going

to take the default behavior approximate match, close

parentheses, Control-Enter, double click, and send it down. Go to the last cell and hit F2. That is absolutely beautiful. We got exactly the same

percentage all the way down, as our much longer IF function. All right, Escape. All right, now, we want to go

look at our example number 4. And this time, I

want to use VLOOKUP to get the correct

bonus commission percentage for every

cell, but then, I want to multiply it by the

sales to get the actual– and that shouldn’t

say percentage symbol, it should say please calculate

the bonus commission dollar amount. All right, so you ready? We going to do the

same exact VLOOKUP. Equals VL, Tab, Left Arrow. I need to have a lookup

value to try and match in the first column. So there it is, a

relative cell reference. Comma, table array. So I remember to put the entire

table– not the field names like a pivot table,

just the first column and any subsequent columns. I’ve highlighted

one, two columns. Now I come down

and hit the F4 key to lock it because I’m

copying this formula down. Comma, column index. I see col. That means I

need to count on my finger until I find the column

that has the thing I want to go and get, and

bring back to the cell. One, two– so I put a two. Comma. Oh, yeah. I’m doing approximate match. I’m leaving it out. By the way, don’t

leave that comma there if you’re going to leave it

out and assume the default behavior of approximate match. Don’t put anything. Don’t even put a comma. It’s simply closed parentheses. And just for a second,

admire how short and sweet that formula is. Control-Enter, double

click, and send it down. I’m going to go to

the last cell and hit F2 to verify that

the relative cell reference and the lock

table are actually working. Now, I’m going to come

to the top cell and F2. Notice VLOOKUP is just

delivering a decimal number to the cell. And don’t get tricked

by number formatting just because this has number

formatting and these cells do not. Remember, all formulas look

at the underlined number. And of course, as

we’ve seen many times in this class, under

that percentage number formatting is a decimal. And we want that decimal. We want to use that decimal

that VLOOKUP is returning and multiply it times the sales. Just like we did in last

video where we had our IF and we took the result of the IF

and multiplied it by our sales, we’re allowed to do the

same thing for VLOOKUP. Control-Enter. Double click and send it down. Go to the last cell and F2. Escape. Now, I see lots of

extraneous decimals. But guess what, I

am not going to use any of these formula results

in any subsequent formulas. So I’m simply going to highlight

and add number formatting. If I were going to add

these, I would have to round. But I’m not, so I’m simply

going to use number formatting. And come up to the dropdown

and select currency. All right, F2 at the top. We’re totally allowed

to use VLOOKUP to do this amazing

approximate match lookup and use the result in a

larger formula, in our case, multiplying. Now, just to emphasize

what VLOOKUP is doing, I’m going to come

up to $39,999.99. Notice VLOOKUP returned to 4%. But what did VLOOKUP do? Well, it took that

number, it raced through until it bumped into

the first number bigger, and jumped back a row. That’s how it knew

how to get that 4%. Now, we’ve done four

examples so far. VLOOKUP totally replaced this. And actually, I forgot, I

want to go back to V1 2. Here we use VLOOKUP with exact

match to look up exactly Quad, but you might be tempted to

make the same mistake over here. This is what we

never want to do. We never want to have to

check every single condition. Any time we have, in our case,

one of five different things we’re putting into the

cell, we used VLOOKUP. Over here on V3 4, when we’re

doing approximate match, we had one of seven things that

we wanted to put into the cell, so instead of checking all

seven things, we used VLOOKUP. All right, let’s go over and

look at our next examples, V 5 and 6. On V 5 6, we have

another common example of how to use exact

match VLOOKUP. Our goal is to get employee

email and phone number. So I need to be able to look

up a particular employee name, find an exact match

in the first column, and then jump over to the

sixth column for email, and the seventh

column for phone. All right, so I’m

going to click here. Cell B16 equals VL, Tab. I’m going to Left Arrow

because I’m trying to look up an employee name. Sometimes, we have an

employee ID instead of a name. Comma, table array. I have to highlight the

whole table without the field names at the top– there’s the first

column– to get a match. And these are all

the potential columns of things we can go and get,

and bring back to the cell. Now I’m going to hit

the F4 key because I am going to copy this to the side. F4. And I need to go back

to lookup value, click, and hit the F4 key to lock

that because as I copy to the side from the email

cell to the phone cell, I need to lock on

the employee name. I very carefully come to the

end and with my eyebeam cursor, now I can comma, and for column

index number, I need to count– 1, 2, 3, 4, 5, 6– so I need to type a six there. The sixth column has the

email I want to go and get. Comma. I’m doing exact match, so you

can put false or type a zero. Both will tell VLOOKUP

to do exact match. Close parentheses. Control-Enter. And I’m going to

copy it to the side. Now this won’t work,

but I come here and F2. Now, I need to change

that column index number. Since phone is in

the seventh column, I’m going to type

a seven and Enter. And just like that, I have

email and phone number. Now, I’m going to click

in the cell right here. Remember, when we’re

doing exact match and we have our lookup table,

we might as well prevent errors. Because if I accidentally type a

Space, those are not available. Control-Z to get

rid of that space. But it’s a simple fix. I’m going to add data

validation list to that cell. So we go up to data, over to

data tools, data validation, click the dropdown for allow. I’m going to say list. The source, it’s the first

column of the lookup table. There we go. Click OK. Now I can simply select Darius. And there we go, the email

and the phone number. Now example number 6, I

want to do exact match. I have a list of these

employees and I just need to get their salary

from the very last column. I’m counting on my fingers,

so that’s all the way to the ninth column. Equals VL, Tab, Left Arrow,

Comma, and the table array– I’m going to highlight the

whole table, all the way to the ninth column. F4 to lock it,

comma, column index– the ninth column has the

thing I want to go and get. Comma. Either false or 0

for exact match. Zero. Close parentheses,

Control-Enter, double click, and send it down. Go to the last cell and hit F2. That’s absolutely beautiful. Hit Escape. Now, we want to go to our

next example, V 7 and 8, and look at two other

approximate match VLOOKUP situations. Here, we have an income

amount and a tax amount. So for this income

amount, I need to get the tax from

our tax lookup table. So you ready? Equals VL, Tab, Left Arrow– to get that sales

number for lookup value. Comma. I’m going to select the table

first and second column. I’m not copying it anywhere,

so I simply type, comma. Column index– well the tax

is in the second column, so I type a two. And I’m doing approximate

match, so I do not need to put anything

for range lookup. The default behavior

is for VLOOKUP to do approximate match. Close parentheses and Enter. So what did VLOOKUP do? It took that number, went

over to the first column of the lookup table– and this column has to

be sorted from smallest to biggest in order for

approximate math to work– it took that number,

raced through until it bumped into the first

bigger one, then it jumped back and knew that that was

the row, and the $120 was the correct tax. VLOOKUP knew that this row was

everything from exactly 5,000, all the way up to,

but not including, 10,000– for all of those

numbers, $120 is the tax. Now, our eighth example. Here we have, if I

Control-Down Arrow, looks like we have

about 100 records. Control-Up Arrow. So this is in payroll. We have the employee

and the sales. And in this business,

they assign a flat amount for commission. So we need to lookup

and match using approximate match, each

one of the employee sales in the first column and

return from the second column the commission. So in the top cell,

equals VL, Tab. Left Arrow to get that sales. Comma. Highlight the table,

F4 to lock it. Comma. Two. because the commission amount

is in the second column, that’s what I want

to go and get. Comma. I am not putting

anything for approximate because that’s the default.

And be sure to not do this. Don’t accidentally

leave a comma there. If you’re going to leave it

out, which is the efficient way to create this formula–

that’s how they designed this function– if you’re

going to leave it out because you want the

default behavior, just don’t put anything. Close parentheses. I love it. That is such a beautiful

and efficient formula. Control-Enter to put the thing

in the cell and keep the cell selected. Double click and send it down. I’m going to Control-Down Arrow

to the very last cell and hit F2. I’m verifying that the cell

references are correct. Escape. Control-Home to jump

up to the top cell. So we saw another

approximate match. It’s very common to

use approximate match to look for a

certain income amount and return a tax or a tax rate. Hit Escape. And we saw payroll

table where we needed to get the commission. Now, if we were going to

finish this, of course, we’d add to get the gross

pay and then calculate our deductions, our

net pay, and so on. All right, we have one

last example for VLOOKUP. I going to use my arrows

to move the sheets. And there is V9. Let’s click on V9. Now, this is the same

table we had last video. And in last video, we needed

to add a sales category. Now in last video, we

used the IF function because there was

two categories– large and small. But for each sales number, I

need to go over this table, use an approximate

match, race through till I find the first bigger

one, figure out which row, go over the second column,

and get that category, and bring it back to the cell. All right. Top cell equals VL, Tab. Left Arrow to get

the sales amount. Comma. And watch this, I’m going

to use my arrow keys– Arrow, Arrow. Now I’m going to

Control-Shift-Right Arrow, Down Arrow, F4 to highlight

that whole table and lock it. That’s an alternative

method to using your mouse. All right, I have

the table, comma. The second column has the

category, so I type a two. I’m doing approximate

match, so I simply assume the default.

Close parentheses. Control-Enter. Double click and send it down. Now just like we

did last video, now we have added a helper column. And if we needed to

create a pivot table– last video, we did country

code and sales category, were just two– but here, we’re not going

to do this in this video, but we’ve added this extra sales

category with this criteria and we could use this new

table with the helper column to build a pivot table. All right, there’s some

homework problems for you to do. And in this video, we saw one

of the most important functions in Excel, we used

VLOOKUP approximate match to populate a new column

with sales categories. Back on 7 and 8, we saw how to

use approximate match VLOOKUP for taxes and commissions,

like in a payroll table. Back on V5 6, a common

example for VLOOKUP is to look up

employee information from various columns in

an employee lookup table. We also saw how

to create a report with employee and salaries. Back on V3 and 4, we saw how

to do approximate match lookup to replace this huge IF, to get

a bonus percentage commission. We also saw how to use

VLOOKUP in a larger formula to deliver a decimal

amount to a formula and then multiply it to

get a commission amount. And then, we started off, V1– a very common

situation for VLOOKUP. We’re looking up a

product name in order to get the product price. And we saw down here how to use

that VLOOKUP look up product price formula in an invoice. And to make sure that VLOOKUP

is going to not deliver an NA, we saw how to add data

validation dropdown list both here and up here. All right, don’t forget

if you like that video, be sure to click that

thumbs up, leave a comment, and sub because there’s

always lots more videos to come from Excel Is Fun. And in our next video,

Excel basics 15, we will get to see the

amazing Excel table feature. All right, we’ll

see you next video.

Wow awesome… thank you so much

Thank for your excellent tutorial

You are amazing! I've learned a lot from your videos and about to attend an Excel test for a possible employment opportunity. Thanks a ton!

Thanks a lot for all lessons you make.❤

Whoa,,, thanks so much Mr. Girvin for your such passionate teaching on the ExcelIsFun VIDS,,,,

GOD bless for all your good works,,,,

Really enjoying your teaching. I've seen online there's some big NEW Excel tool "xlookup" that people claim now surpasses "vlookup" – any chance in the near future you'd do a video on it please? Best Regards!