ContributionsMost RecentMost LikesSolutionsRe: Need help on whether to use IF or Caseyes so i think best way is to just export it into excel and the Vlookup , add the new column to parent table , and call it done. Didn't think outside the box(quickbase)Re: Need help on whether to use IF or CaseI created the table with Locations and regions, i am having trouble linking the two tables now. my parent table uses a company # as primary reference , and each company has 1 location. i then try to relate the tables on location to pull the region to the master , but it returns nothing.Need help on whether to use IF or CaseI have a list of locations that i am trying to make a formula derived from a current field. but naturally i have about 100 locations that then have corresponding regions , so i would have 3 statements with lists of locations. Basically trying to do a vlookup and use a temp table from a list , IF([location] = ("DFW","HOU","SAT"), Central) ,("DEN", "PHX","SEA"), West) , ("MIA", "TPA", "JAX"), East) CASE([locaiton] =("DFW","HOU","SAT"), Central) ,("DEN", "PHX","SEA"), West) , ("MIA", "TPA", "JAX"), East) or should i just create a new table with master list and then try and link the two tables ?