Instances in other sheets

cmcasper

New Member
Joined
Sep 12, 2011
Messages
34
I've got a multiple sheet Excel file. Is there a formula that can return a "1" if there is an exact instance of what is in Cell A1 anywhere on a different sheet?
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Watch MrExcel Video

Forum statistics

Threads
1,109,165
Messages
5,527,187
Members
409,749
Latest member
BorisYeltsin

This Week's Hot Topics

Top