CODEWITHSUNDEEP
excelcomparelookup
Billef32
Billef32

Reputation: 285

Excel - return "true" if a value exists in both columns

I have two columns of data. column A and column B. in the third column (C) I want to type a formula that will return "true" if a data in column B exists anywhere in column A. Just this :) Thank you in advance.

Upvotes: 7

Views: 67410

Answers (1)

Firefly
Firefly

Reputation: 124

Try This:

=NOT(ISNA(VLOOKUP(B1,A:A,1,0)))

Assuming you are starting in cell C1.

VLOOKUP returns the value of B1 in the column A, or #N/A if it's not found. ISNA will return TRUE if no value is found, or FALSE if it is, finally NOT negates the result such that it will return TRUE if value is found and FALSE otherwise.

Upvotes: 9

Related Questions