Mar 24 2021 03:05 AM
Mar 24 2021 03:40 AMSolution
Insert a new column in the first table, and name it Match, for example.
Enter the following formula in the first data row of that column:
=ISNUMBER(MATCH([@[Item Name]],Table3[Item Name],0))
where Table3 is the name of the other table. Excel should automatically populate the table column with that formula.
Mar 26 2021 01:26 AM - edited Mar 26 2021 01:29 AM
Hello Hans !! Your solution worked but ,, what if the item name has the string values and i want to have a new column which does not match ??