Mapping

[UserExcel]

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

[#2 · Accepted solution]

@UserExcel 

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.

 

[#3]

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

[#4]

@UserExcel 

What would you like the result to look like?