Up next in 10
Simple Excel VLOOKUP Tutorial That Will Make You a Pro
4K views
Feb 9, 2025
Learn how to master Excel's VLOOKUP function in this straightforward tutorial designed for beginners! This step-by-step guide breaks down the basics, helping you retrieve data efficiently and boost your productivity. Whether you're managing spreadsheets or organizing data, this tutorial will give you the confidence to use VLOOKUP like a pro. Perfect for students, professionals, and Excel enthusiasts looking to sharpen their skills. Watch now and transform your data management game! Learn More at: https://excelweez.com/
View Video Transcript
0:01
hi everyone welcome back to my YouTube
0:04
channel so today's video we are going to
0:07
learn how to use vup for data retrieval
0:11
in Excel if you're new to excel vook up
0:15
is an Excel function that allows you to
0:18
research for value in one column of your
0:20
data and return a corresponding value
0:23
from another column in that same table
0:26
and this can also apply if you're using
0:29
two different sheets
0:30
you can get uh data from one sheet and
0:33
use it in the other sheet
0:37
so in the context of this video we are
0:40
going to have we have our sales data on
0:44
the sales data sheet we also have price
0:47
list on our price list sheet so we are
0:50
going to be using the two datas
0:54
to to calculate in the sales data we'll
0:57
be calculating the total Revenue that
1:00
was uh
1:03
used total
1:07
revenue sorry
1:10
Revenue so we will actually get to see
1:14
for this uh product product a b c to e
1:19
and their
1:21
corresponding corresponding prices will
1:24
get to know uh the amount of money this
1:27
person made if this is the am theant
1:29
quantity that is sold for each
1:33
product we will use V lookup for this so
1:37
you could use it in different other
1:39
context if you need to know the
1:41
professions of people just uh the data
1:45
for you may be different but the same
1:48
way to use vup is the same let's
1:53
start uh go click on your total
1:58
revenue column that is column C or
2:03
C2 once you click on
2:06
it uh use your equal sign to start
2:13
your Excel function and then type your V
2:17
lookup V
2:18
lookup you can click on your tab on
2:22
your laptop so you can get the the
2:26
formula quick once you click on it
2:29
you'll be you'll a small popup down here
2:32
will come that says you've got your look
2:36
lookup value your table array your index
2:39
number and the range look up so these
2:42
are the things that we need in order to
2:44
make sure that we have everything
2:48
working out well so the first thing
2:50
you'll do you will go
2:53
to you click to product the product that
2:57
you need that is 8
3:00
to uh type in a comma to separate the
3:04
element of your Excel function and then
3:08
once you're done with
3:11
that move on to price list because now
3:15
you you need
3:20
to you need to get all the range of the
3:23
data that you need for this formula
3:26
so ensure everything has been selected
3:29
in this case we are selecting both
3:32
product price including the headings so
3:35
on top here you'll have A1 to
3:38
B6 uh give it a comma as well and then
3:42
you need to ensure that you type the
3:46
column in
3:47
which the other the price that you need
3:51
is on in this case uh colum a is 1
3:55
column B is two C3 and and more like
4:01
that so in this case we'll type two
4:05
because our price is on column two and
4:10
then type in comma again and you have to
4:13
at this stage you have to say whether
4:16
you will need an exact match or an
4:19
approximate match if you type in true it
4:22
means that you will get a certain number
4:26
that but it's not 100% what you need so
4:29
to type in
4:34
false false some people try to skip it
4:38
but
4:39
something uh that's
4:41
not that's not what you need and then
4:45
now since this is the formula that you
4:48
need but now you'll have to multiply it
4:54
with you have to multiply it you move
4:57
back to your sales say sheet and
5:00
multiply it with now the the quantities
5:03
that you need this is going to be
5:06
B2 and then click on
5:11
Tab sorry on enter and see you've got
5:15
50 and then click and drag all the way
5:19
to to the last one and here you have
5:22
everything you
5:24
need you see so now we have our total
5:27
revenue if you could do this the manual
5:30
way you could have just said um for
5:33
product a which cost 10 let's say
5:38
$10 uh this person sold five pieces so
5:42
10 by five you get 50 and same goes for
5:47
product B all the way to product
5:51
a so that's how you use your vook up for
5:56
data retrieval in Excel using different
5:59
sheet it's the same if you are using the
6:03
same data in the same sheet so just
6:06
ensure that you use the formula as it is
6:09
you don't skip a bit of the formula and
6:13
if you just understand every bit of the
6:15
formula then you're good to go thank you
6:18
very much for watching and again if you
6:21
like this video leave us a thumbs up a
6:23
comment in the comment section and see
6:27
you again in the next video bye-bye
6:31
oh