Hi all,

I have a Table which I have setup to identify recharges based on 2 sets of rules. I'm currently using the tablematch function to pull this data into my main table. Sample of my current Rules table is as below;

Is Recharge      Cost Center         Account

Yes                    X0000N               30000

However, what this is treating it as an AND statement. What I'd like to do is use the above table to say;

1. If the expense falls into any of these Cost Centers, it is a recharge. 

2. If the expense falls into any of these accounts regardless of the Cost Center, it is a recharge. #

Hope this makes sense!

Thanks all,

Mike 

@Michael Shamsiev

You could add a column to your Account List and Cost Center list to identify them as a recharge, create a lookup to pull them into your Actuals and create an If statement to look at Account column then the Cost Center column.

It should work with a wild card in each column:

Is Recharge      Cost Center         Account

Yes                    X0000N              *

Yes                                *              30000