I need a simple formula for working out a suburb and it puts out a selected output.
eg: if the suburb gorokan or toukley is in the field, the formula puts in KPM1. IF the suburb is hamlyn terrace it puts in KPM2 etc etc This will apply to 5 different outputs ( KPM1 KPM2 KPM 3 KPM4 LM1) based on the suburb.
This formula works great for the single suburb but I cant get it to output KPM1 if I put multiple suburbs in there
I know it will be nested IF formulas but I just cant get this first one to work as expected.
It will be simple im sure! lol