1 thumb up

Excel help, please!

Is there a way in Excel to find if the value of a cell is equal to the value of one of the cells in an array? I was sure it would take me 2 minutes to find how to do it and I've been messing around with it for almost an hour now.

  • 485 views
Share Send to a friend Watch Report
 
 

Posted Answers

 
1146 thumbs up

There is a function that does it: VLOOKUP

For example : you have a column filled with data - column A

You have a single cell (c1) that you wish to compare to all the data in column A : vlookup(c1,a1:a27,1,false). This will just give you if there is a match or no.

but I suggest that you add another column with the number of rows so you can get immediately the row where the match appears. So let us add Column b with the numbers , and  the function will become: vlookup(c1,a1:a27,2,false)

 

 


Posted 2 years ago ( permalink )
In reply to Jupiter's question
Rated as
Best Answer
0
3

Helpful?

line
line
line



 
20 thumbs up

Posted 2 years ago ( permalink )
In reply to Jupiter's question
ElynnWQ was invited by Yedda to answer this question.

Rated as
#-2147483648 out of 1
0
0

Helpful?

line
line
line



 
63 thumbs up

Ordinary People Discovering Extraordinary Abilities

Not So Smart Builder


Posted 2 years ago ( permalink )
In reply to Jupiter's question
dudushmaya was invited by Yedda to answer this question.

Rated as
#-2147483648 out of 1
0
0

Helpful?

line
line
line



 
2 thumbs up

Posted 2 years ago ( permalink )
In reply to Jupiter's question
yosicohen was invited by Yedda to answer this question.

Rated as
#-2147483648 out of 1
0
0

Helpful?

line
line
line



 
27 thumbs up

Posted 2 years ago ( permalink )
In reply to Jupiter's question
EscApe was invited by Yedda to answer this question.

Rated as
#-2147483648 out of 1
0
0

Helpful?

line
line