Forum Discussion
Find match of column separted values in another table
Hi I have in Excel two tables Tab1 and Tab2 (see image). I would like to get the result of Table1.Result column by finding all values of Table1.ID in Table2.ID. How can I get this result without us...
I was so focused on how to make the id column work i didn't think how the city name in the result column was an easier find (assuming the city names are unique)
You are right, in names could be misprints or wrong spelling, from this point of view your formula for counting based on IDs is more reliable.