Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Comparing Cells

Status
Not open for further replies.
ccjjscb

ccjjscb

Technical User
Jan 18, 2006
29
0
0
US
I am trying to compare a cell to 60 other cells and if it is the same as any of those cells put that information in another cell. Example:
If A2 is = to any cell from Q2 through V11 then I2 would = A2. I know this may be a simple formula but I am lost on how to do it. I have a very limited knowledge of advanced Excel formulas. I have looked through the FAQs and searched but found nothing that would help.
Thanks in advance for any and all help
Chris
 
Sort by date Sort by votes
Put in cell I2:

=IF(COUNTIF(Q2:V11,A2)>0,A2,"")

--Lilliabeth
 
Upvote 0 Downvote
Thanks for the help Lilliabeth,
I knew it had to be a simple one.
Thanks
Chris
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

N1GHTEYES
  • Question
Count range overlap cells
Replies
3
Views
132
N1GHTEYES
N1GHTEYES
scubafrog79
  • Locked
  • Question
Formula for checking cells for value and then subtract value 1
Replies
8
Views
122
SkipVought
S
RosaseLLEN
  • Locked
  • Question
calculating the distance between cells in excel (randomize moving cells)
Replies
4
Views
89
strongm
strongm
caykamanj1966
  • Locked
  • Question
Place a hyperlink on multiple cells with text in Microsoft Excel
Replies
9
Views
143
Andrzejek
Andrzejek
pendle666
  • Locked
  • Question
Change colour of cells based on dropdown list value in another - Excel professional plus 2016 1
Replies
5
Views
94
pendle666
pendle666

Part and Inventory Search

Sponsor

Back
Top