# Excel - COLUMN Function Problem - Expert Solution

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

I need a formula to check one cell on the 1st sheet (e2) with a list on another sheet (Sheet1) in the A column, starting at A1
Solved by O. D. in 21 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 15/03/2018 - 12:18
Hi
User 15/03/2018 - 12:18
Hello!
Excelchat Expert 15/03/2018 - 12:18
welcome to got it pro
User 15/03/2018 - 12:19
Thank you, this is nice. The 1st time I've used the service
Excelchat Expert 15/03/2018 - 12:19
ok
Excelchat Expert 15/03/2018 - 12:19
User 15/03/2018 - 12:19
I need a formula to check one cell on the 1st sheet (e2) with a list on another sheet (Sheet1) in the A column, starting at A1
Excelchat Expert 15/03/2018 - 12:19
which formula ?
User 15/03/2018 - 12:19
I have been trying =LOOKUP(E2,Sheet1!A:C,FALSE)
Excelchat Expert 15/03/2018 - 12:20
oh
Excelchat Expert 15/03/2018 - 12:20
think you want to do a vlookup
User 15/03/2018 - 12:20
Ok. I did just change that to the suggestion and now get a N/A
Excelchat Expert 15/03/2018 - 12:20
ok
Excelchat Expert 15/03/2018 - 12:20
i will help
User 15/03/2018 - 12:20
I know the value is in the cell e2
Excelchat Expert 15/03/2018 - 12:20
i have pasted some data in sheet 2
User 15/03/2018 - 12:21
Ty :)
Excelchat Expert 15/03/2018 - 12:21
you have not specified a number before false
Excelchat Expert 15/03/2018 - 12:21
it can be 1,2 or 3 as per ou case
User 15/03/2018 - 12:22
What is the number signifying?
Excelchat Expert 15/03/2018 - 12:22
it you want to show 3rd column from your range then use 3
Excelchat Expert 15/03/2018 - 12:22
i have used 3 which means it will return column C
User 15/03/2018 - 12:22
ohhh
Excelchat Expert 15/03/2018 - 12:22
since i have seleceted A,B and C
Excelchat Expert 15/03/2018 - 12:22
does this help?
Excelchat Expert 15/03/2018 - 12:22
User 15/03/2018 - 12:23
Ok
Excelchat Expert 15/03/2018 - 12:23
User 15/03/2018 - 12:23
I tried =VLOOKUP(E2,Sheet1!A,1,FALSE) --since my column is A, I put a 1
Excelchat Expert 15/03/2018 - 12:23
it really helps
User 15/03/2018 - 12:23
I will!
Excelchat Expert 15/03/2018 - 12:23
yes
User 15/03/2018 - 12:23
come back as #NAME
Excelchat Expert 15/03/2018 - 12:24
can you paste your data here so that i can help
User 15/03/2018 - 12:24
Sure, where would you like me to post it?
Excelchat Expert 15/03/2018 - 12:24
Excelchat Expert 15/03/2018 - 12:24
just some sample data for me to work
User 15/03/2018 - 12:25
ok
User 15/03/2018 - 12:26
The formula I'm having issues with is in V1, the data I'm trying to search for in e2 is sheet 4
Excelchat Expert 15/03/2018 - 12:29
what do you want to show in V1
Excelchat Expert 15/03/2018 - 12:29
?
User 15/03/2018 - 12:29
Whether or not a word in e2 is on sheet4
Excelchat Expert 15/03/2018 - 12:29
ok
User 15/03/2018 - 12:30
The word list are metaphors, and the calculation is the figurative meaning of words in the selected tweet
User 15/03/2018 - 12:30
theoretically if there are metaphors, the message intends to communicate figurative meaning
User 15/03/2018 - 12:30
ty so much, I've been trying everything
Excelchat Expert 15/03/2018 - 12:31
that word is not there i the list
User 15/03/2018 - 12:32
? on sheet4, row 229 it says "grassroots"
Excelchat Expert 15/03/2018 - 12:32
see my formula in W2
Excelchat Expert 15/03/2018 - 12:33
no
Excelchat Expert 15/03/2018 - 12:33
it matches the entire text in the cell
Excelchat Expert 15/03/2018 - 12:33
"grassroots With grateful hearts, Renee and I join our community in praying for these soldiers and the families they are leavin\u2026 https:\/\/t.co\/h4lkENpcQo","tr
Excelchat Expert 15/03/2018 - 12:33
not just a word
Excelchat Expert 15/03/2018 - 12:34
hope thus helps
Excelchat Expert 15/03/2018 - 12:34
do you get it?
User 15/03/2018 - 12:34
so it has to match the entire cell
Excelchat Expert 15/03/2018 - 12:34
yes
User 15/03/2018 - 12:34
oh, I was looking for a formula to find if a word in one cell matches any on another sheet
User 15/03/2018 - 12:34
User 15/03/2018 - 12:35
do I have to include an exact statement?
Excelchat Expert 15/03/2018 - 12:35
then you need to specify that word in the formula
Excelchat Expert 15/03/2018 - 12:36
see formula n2
Excelchat Expert 15/03/2018 - 12:36
it is searching grassroots
User 15/03/2018 - 12:36
ok
Excelchat Expert 15/03/2018 - 12:37
yes
Excelchat Expert 15/03/2018 - 12:37
hope this helps
User 15/03/2018 - 12:37
Hmm that's clever, but I want to search the E cell for the presence of any word on sheet 4
User 15/03/2018 - 12:37
Not a specific word, but a range of words/phrases on the separate sheet.
Excelchat Expert 15/03/2018 - 12:37
but lookup function search the entire value in the cell
Excelchat Expert 15/03/2018 - 12:38
your cell should have proper values to be search upon
Excelchat Expert 15/03/2018 - 12:38
in this case E1 is having a sentence which is not there in sheet 4
User 15/03/2018 - 12:38
ok
Excelchat Expert 15/03/2018 - 12:38
just play wih the formula
User 15/03/2018 - 12:39
which one?
User 15/03/2018 - 12:39
I'll certainly do that
Excelchat Expert 15/03/2018 - 12:39
vlookup formulas
Excelchat Expert 15/03/2018 - 12:39
n2 or w2
User 15/03/2018 - 12:39
ok ty sir
Excelchat Expert 15/03/2018 - 12:39
User 15/03/2018 - 12:39
will do
Excelchat Expert 15/03/2018 - 12:39
welcome
Excelchat Expert 15/03/2018 - 12:40
User 15/03/2018 - 12:40
Will do!
User 15/03/2018 - 12:40
ty

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.