How to use VLOOKUP in Microsoft Excel
How to use VLOOKUP in Microsoft Excel
Use VLOOKUP when you need to find things in a table or a range by row in Microsoft Excel. For example, look up a price of an automotive part by the part number, or find an employee name based on their employee ID. Learn more at: https://msft.it/6006VGuDk
► Subscribe to Microsoft 365 on YouTube here: https://aka.ms/SubscribeToM365
► Follow us on social:
LinkedIn: https://www.linkedin.com/showcase/mic…
Twitter: https://twitter.com/Microsoft365
Instagram: https://www.instagram.com/microsoft365/
Facebook: https://www.facebook.com/Microsoft365/
► For more about Microsoft 365, visit https://msft.it/6006Tc8Z4
#Microsoft365 #MicrosoftExcel #VLOOKUP
Content
0 -> Hi, I’m Jimmy from Microsoft
Store.
2.369 -> Today I’m going to show you how
to use VLOOKUP in Excel.
6.439 -> Let’s take a look.
7.874 -> In the “Addresses” Excel sheet
shown here,
10.41 -> I have a list of family and
friends.
12.712 -> Their names are in column A,
14.781 -> and their addresses in
columns B and C.
18.184 -> If I click the “Phone Numbers”
sheet below,
20.754 -> all the same names are listed in
a different order,
23.89 -> with phone numbers and
birthdays.
26.126 -> What I want to do is
consolidate each phone number
28.628 -> into my “Addresses” sheet
30.397 -> without manually copying each
phone number over,
33.533 -> so I’ll use VLOOKUP.
35.735 -> If you want to bring over their
birthdays as well,
38.705 -> you can use XLOOKUP,
40.64 -> a feature for Microsoft 365
subscribers that
43.977 -> allows you to bring over
multiple columns.
46.88 -> Now I’ll click back into the
“Addresses” sheet.
49.649 -> In the top row of the
“Phone Numbers” column,
52.118 -> I’ll type the equals sign,
VLOOKUP,
56.423 -> and an open parenthesis.
58.224 -> The first thing to add in the
formula is the lookup value.
62.062 -> Since each name is what I want
to reference,
64.964 -> my lookup value will be the
names, so I’ll highlight them.
69.502 -> Then I’ll add a comma to move
to the next step in the formula.
73.773 -> Now I need to add the range
or area where I want Excel
77.177 -> to look for the data I need.
79.312 -> In this case, that’s the names
and phone numbers
82.415 -> on my other sheet,
83.416 -> so I’ll click back into the
“Phone numbers” sheet.
86.119 -> Then I’ll highlight my range
A2 through B15.
90.29 -> I’ll add another comma to the
formula,
92.992 -> and now I’ll enter the number
“2” because I want it
96.496 -> to pull the phone numbers
97.464 -> I need from the second column
of the highlighted range.
101.534 -> I’ll add another comma to the
formula to move
104.304 -> on to the last step,
105.638 -> and here, I will type “FALSE”
because I want the names
108.808 -> to be an exact reference.
110.81 -> I know the names will match
exactly, so no need to
113.813 -> allow for approximate
references.
115.949 -> Now I’ll hit “Enter”, and all
the
118.685 -> phone numbers will move over to
my “Addresses” sheet.
122.288 -> VLOOKUP saved me time that I
would normally spend manually
126.392 -> copying each phone number and
pasting them to
129.062 -> my “Addresses” sheet.
130.463 -> You’ve got to love formulas!
131.998 -> You just learned about VLOOKUP
134.067 -> a great tool for your journey
within Excel
136.903 -> and its lovely formulas.
138.671 -> See you in our next video, and
thanks for watching.
141.574 -> (upbeat music)
Source: https://www.youtube.com/watch?v=pP-fsrhndS4