Hi, I am trying to use several tables in an if formula but I haven't gotten it to work.
I have one master table which I want to look up to first, however, if the lookup value contains City (Suburb), City2(Suburb) or City3 (Suburb) I want to look up from three different lookups tables.
I have 4...