Comparing Cells

[ccjjscb]

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

 

[Lilliabeth]

Put in cell I2:

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

--Lilliabeth

 

[ccjjscb]

Thanks for the help Lilliabeth,
I knew it had to be a simple one.
Thanks
Chris