CODEWITHSUNDEEP
excel
Alexander
Alexander

Reputation: 1

Excel matching data in columns

So, I have a around 10,000 values in column A and then about 10 values in column B. I want in column C, for example if cell A1 equals value B1 to B10, then return true, then do this for the 10,000 columns, so if cell A3455 equals any values between B1 and B10. Is there a super quick way?

Upvotes: 0

Views: 26

Answers (1)

FloLie
FloLie

Reputation: 1840

1) Put that in C1

=If(Countif($B$1:$B$10, A1)>0, TRUE, FALSE)

2) Copy it down till the last value in column A. 3) Copy the column, and over paste it with values only. 4) Copy again and paste transposed if you really want 10k columns. If you actually meant you want TRUE/FALSE all in column C just leave out steps 3+4

Upvotes: 1

Related Questions