Comparing data across 2 table or sheets?

[rainbow1112]

Right now i'm using the if function to compare. If I would like to compare data inside a table how should I do that?

example table 1 if a and 100k matched table 2 it will return true. can I do that with the match function? i tried it but encountered error..

Table 1
a​	100,000.00
Table 2
b​	200,000.00
a​	100,000.00

 

[rainbow1112]

Right now I can compare 1 data in table 1 against the data in table 2.

If I want to compare 2 data in table 1 against 2 data in table I could not do that..

=If(match(a2, a4:b5, 0) "true", "false")