Excel - How to Use a VLOOKUP Formula - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I need help with a VLOOKUP formula. How do create a formula.
Solved by K. A. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 04/02/2018 - 10:26
hello dear, welcome to got it pro
User 04/02/2018 - 10:26
Hi
User 04/02/2018 - 10:26
I need help with a vlookup formula
Excelchat Expert 04/02/2018 - 10:26
would you have any data on which you would like to use vlookup
User 04/02/2018 - 10:27
No just in general
Excelchat Expert 04/02/2018 - 10:27
ok
User 04/02/2018 - 10:27
could you walk me through a vlookup
Excelchat Expert 04/02/2018 - 10:27
yes, why not
User 04/02/2018 - 10:27
so say I have a list of 10 names and I want to create a vlookup
Excelchat Expert 04/02/2018 - 10:28
In Vlookup, V stands for vertical
Excelchat Expert 04/02/2018 - 10:28
ok create a list of names
User 04/02/2018 - 10:28
ok
User 04/02/2018 - 10:29
now how do I create a vlookup in another cell to only say
User 04/02/2018 - 10:29
look up molly
Excelchat Expert 04/02/2018 - 10:29
now write some thing in front of their names
User 04/02/2018 - 10:29
in another cell?
Excelchat Expert 04/02/2018 - 10:29
In front of names, In column B
Excelchat Expert 04/02/2018 - 10:29
anything
User 04/02/2018 - 10:30
ij
User 04/02/2018 - 10:30
ok*
Excelchat Expert 04/02/2018 - 10:30
yes, its ok now
Excelchat Expert 04/02/2018 - 10:30
now i created a sheet two
Excelchat Expert 04/02/2018 - 10:31
write down just three of the names here
User 04/02/2018 - 10:31
ok wait now I realized I need to do a formula where if it says face care look up pam
User 04/02/2018 - 10:31
how do I do that
Excelchat Expert 04/02/2018 - 10:31
I am gona show you vlookup, just do what i said
User 04/02/2018 - 10:32
ok
Excelchat Expert 04/02/2018 - 10:32
wrute down three random names in sheet 2, that existing in sheet 1
User 04/02/2018 - 10:32
ok
User 04/02/2018 - 10:32
i did
Excelchat Expert 04/02/2018 - 10:33
now look
User 04/02/2018 - 10:37
what does the 1/2 mean
User 04/02/2018 - 10:37
2*
Excelchat Expert 04/02/2018 - 10:39
dear in this formula, "A1" is a value to find in 1st column of range A3:A10" of sheet1
Excelchat Expert 04/02/2018 - 10:40
and 2 means, pick a value in 2nd column of range
Excelchat Expert 04/02/2018 - 10:40
false means exact match.
User 04/02/2018 - 10:40
how come it didn't work
Excelchat Expert 04/02/2018 - 10:42
wait i,ll semding you an excel file
Excelchat Expert 04/02/2018 - 10:42
ith vlook up formula
User 04/02/2018 - 10:43
ok
Excelchat Expert 04/02/2018 - 10:45
here it is
[Uploaded an Excel file]
Excelchat Expert 04/02/2018 - 10:45
you can checck

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.