Occasional Contributor

I have two tables one with column name,,, item id and item name

another table with item name


How do i find  out that particular  item name in a cell  in first table   is also  on another table ???

3 Replies
best response confirmed by UserExcel (Occasional Contributor)


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.



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 ??


What would you like the result to look like?