How to find matching values from one column to another in Microsoft XL

There are two columns in XL with A and B, If we wanted to search all the column A values in column B values below is the formula to execute

Find matching values in another column in XL:

=NOT(ISERROR(MATCH(A1,$B$1:$B$4,0)))


For If the value is found, it returns TRUE, otherwise FALSE will be placed in C1 for the rest of the columns, drag over the C1 to below rows it’ll search the rest of A values in B1-B4 and returns the response in C column


Leave a Reply

Your email address will not be published. Required fields are marked *

Enable Notifications OK No thanks