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.
