Matching terms in separate tables.

[Confused!]

Table 1;
Cell A1 0.352941176
Cell A2 0.125
Cell A3 -8

Table 2
B1 -2.833333333
B2 -8
B3 0.125

Table 3
A1 to B1 = False
A1 to B2 = False
A1 to B3 = False
A2 to B1 = False
A2 to B2 = False
A3 to B3 = True
etc.

Please give me the formula that will match Cells A2 with B3 and A3 with B2.

 

[Gerald Higgins]

This is probably do-able, but I'm not completely clear what you want ?

Do you already have Table 3 set up, showing
A1 to B1
A1 to B2
and so on, and you just need to add the TRUE / FALSE result ?
If yes, do you actually have this

A1 to B1

in a cell, or something else ?

If you simply want to check whether a value in A1 is found in the list B1:B3

=vlookup(a1,b1:b3,1,false)

If the value in A1 is NOT in B1:B3, you will get a #NA error.
If the value in A1 IS in B1:B3, the value in A1 will be returned.
There are various ways to force the VLOOKUP to show something else in either case.