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
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

JoeMo

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

Watch MrExcel Video

Forum statistics

Threads
1,089,936
Messages
5,411,365
Members
403,362
Latest member
DoubleJay

This Week's Hot Topics

Top