excelexcel-formulamatchvlookupexact-match

How to match Two columns with case sensitive in excel?


Hi I have 2 columns A and B , in column C I need to display true if value in column A exists in Column B with exact case sensitive else false. How can I achieve this? I use vlookup and match functions but those are not matching columns with case sensitive. Any help will be appreciated.


Solution

  • EXACT MATCH Formula

    Searches for an exact (case-sensitive) match of the value of a cell of column A, in a range in column B and returns TRUE if found, FALSE if not found or "" if cell value is "".

    The following is an array formula and has to be entered by
    holding LEFT CTRL SHIFT and pressing ENTER:

    =IF(A1="","",NOT(ISERROR(MATCH(TRUE,EXACT(A1,B$1:B$10),0))))
    

    Afterwards in the formula bar it will look like this (braces {...}):

    {=IF(A1="","",NOT(ISERROR(MATCH(TRUE,EXACT(A1,B$1:B$10),0))))}