=IF(SUMPRODUCT(COUNTIF((INDIRECT("["&N1&"]"&"sheet"&{1,2,3}
&"!"&"C:C")),M1))1,"YES","NO")



On Nov 14, 4:58*pm, puiuluipui
wrote:
Hi, it's working, but it's looking only in one sheet. Can your code search in
5 sheets? And i need to display "yes" if the code finds a duplicate nr, and
"no" if doesn't find a duplicates.
Can this be done?
Thanks!!!!

"muddan madhu" wrote:
Try this

=COUNTIF(INDIRECT("["&N1&"]"&"Sheet1!$C:$C"),C5)

On Nov 14, 2:56 pm, puiuluipui
wrote:
Hi, i have a number in "C5" and i need to search for this number in another
workbook. I need to search only in column C:C.
But i need an indirect function because the name of book2 will change every
week. I will put in "N1" the name of other workbook.

Can this be done?
Thanks!

.