Compare numbers in columns in two tables

[whynot]

I have two tables. One has four columns the other has three columns. I need to compare and determine if the numbers in column 4 in table 1 are included in column 3 in table 2. If the numbers are in both columns, i would like the output to be "yes". Pictures of the tables are below. The columns i am trying to compare are circled in yellow. Thank you.

Table 1

Table 2

​

 

[Cubist]

Try:

=IF(ISNUMBER(MATCH([@[Expense Amount]],Table2[CC],0)),"yes","no")

 

[whynot]

Thank you for the suggestion, but unfortunately, it did not work. i am likely doing something wrong.

here is the formula i used. =IF(ISNUMBER(MATCH([@Charged],Expensed[@[Expense Amount]],0)),"yes","no")

column 1 has the formula. This is table 1 and i have pasted Table 2 after Table 1.

 

[Cubist]

Your "Charged" column is left aligned indicating that those are texts instead of numbers. Turn it to numerical type, then it should work.

 

[whynot]

Thank you!!!