**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.*