Hi all. I am kinda new to formulas and was hoping there was a way to make a formula that can take into account data from other tables? What I am trying to do here is assign certain data a simplified number. Example: If the number in column A from table 1 is between 1,000 and 1,999 then it is assigned ‘1’ in table 2. If the number in column A from table 1 is between 2,000 and 2,999 then it is assigned ‘2’ in table 2. So on and so forth.
It sounds like you will want to look into lookup fields:
Thanks Scott. I tried lookup but all it will do is bring info from the field I select to the LookUp. What I am trying to do is create a condition that says:
- If price in field ‘total net income’ is <$1000 in table a
- Then add #1 to field ‘total net income’ in table b
- If price in field ‘total net income’ is >1001 but <1999 in table a
- then add #2 to field ‘total net income’ in table b
So on and so forth. Is this a formula? automation?
Once you lookup the number into a lookup field, then you can create a formula that compares the value of that lookup field to whatever you want.
You are right. Then hide that field. Thanks so much!
This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.