Cross-reference cell

polska2180

Active Member
Joined
Oct 1, 2004
Messages
345
Hi I need to cross reference Sheet1A1 against sheet2a:a. If match is found say true if not blank or false. Thanks
 

JoeMo

MrExcel MVP
Joined
May 26, 2009
Messages
16,645
Code:
=IF(ISNA(MATCH(Sheet1!A1,Sheet2!$A:$A,0)),"","true")
 

Forum statistics

Threads
1,078,337
Messages
5,339,632
Members
399,316
Latest member
LeroyWork

Some videos you may like

This Week's Hot Topics

Top