Match Not Working in Table

[happyhungarian]

Hi, I have a table with three columns. The first two columns are populated with data and I was going to use the third column to enter a formula to find a row that contains a certain combination. The formula I used as "MATCH(1,(A2=[ColumnA])*("direct"=[ColumnB]),0)" but it returns "0" for every row. However, when I do this formula OUTSIDE of the table it works just fine. Why doesn't this formula work when it's contained in a table? Anything I can do to fix?

Thanks!

Jesse

 

[Fluff]

That formula works for me in a table.
Which column is the formula in? You may well be getting a circular reference.