Help

Re: IF Formula From A Different Table

631 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Rory_Sacks
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

4 Replies 4

It sounds like you will want to look into lookup fields:

Rory_Sacks
5 - Automation Enthusiast
5 - Automation Enthusiast

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
    AND
  • 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.

Rory_Sacks
5 - Automation Enthusiast
5 - Automation Enthusiast

You are right. Then hide that field. Thanks so much!