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

how can i help you?

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

please try

User
15/03/2018 - 12:23

Ok

Excelchat Expert
15/03/2018 - 12:23

please do give good rating

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

here on spread sheet

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

maybe I asked that incorrectly

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

as per your requirement

User
15/03/2018 - 12:39

will do

Excelchat Expert
15/03/2018 - 12:39

welcome

Excelchat Expert
15/03/2018 - 12:40

please do give good rating

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