How to use multiple If statements across many variants (Array)??

%3CLINGO-SUB%20id%3D%22lingo-sub-3207591%22%20slang%3D%22en-US%22%3EHow%20to%20use%20multiple%20If%20statements%20across%20many%20variants%20(Array)%3F%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3207591%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20list%20of%20all%20of%20the%20towns%20that%20make%20up%20my%20state%20and%20each%20town%20correlates%20to%20a%20specific%20council%2Fregion.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20been%20trying%20to%20work%20out%20how%20to%20write%20a%20formulate%20that%20links%20the%20town%20to%20its%20correct%20council.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%2C%20If%20I%20type%20in%20a%20town%20name%20ie%20Aireys%20Inlet%20in%20one%20cell%20I%20would%20like%20the%20next%20cell%20to%20automatically%20generate%20the%20applicable%20council%20name%20ie%20Geelong.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20haven't%20been%20able%20to%20find%20a%20way%20to%20do%20this%20as%20I%20have%20about%2074%20councils%20and%20some%20councils%20have%20upto%2060%20towns.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20on%20this%20would%20be%20GREATLY%20appreciated!%26nbsp%3B%3C%2FP%3E%3CP%3EFingers%20Crossed!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3207591%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3207880%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20use%20multiple%20If%20statements%20across%20many%20variants%20(Array)%3F%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3207880%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1316377%22%20target%3D%22_blank%22%3E%40smoss26%3C%2FA%3E%26nbsp%3BWell%2C%20I%20you%20have%20a%20list%20somewhere%20with%20all%20the%20councils%20and%20towns%2C%20it's%20no%20more%20than%20using%20one%20of%20several%20lookup%20functions%20to%20find%20the%20council%20that%20belongs%20to%20the%20town%20selected.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELook%20into%20VLOOKUP%2C%20INDEX%20combined%20with%20MATCH%20or%20XLOOKUP.%20It%20depends%20on%20the%20Excel%20version%20you%20work%20with.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Visitor

I have a list of all of the towns that make up my state and each town correlates to a specific council/region. 

I have been trying to work out how to write a formulate that links the town to its correct council. 

 

For example, If I type in a town name ie Aireys Inlet in one cell I would like the next cell to automatically generate the applicable council name ie Geelong.  

 

I haven't been able to find a way to do this as I have about 74 councils and some councils have upto 60 towns. 

 

Any help on this would be GREATLY appreciated! 

Fingers Crossed! 

 

1 Reply

@smoss26 Well, I you have a list somewhere with all the councils and towns, it's no more than using one of several lookup functions to find the council that belongs to the town selected.

 

Look into VLOOKUP, INDEX combined with MATCH or XLOOKUP. It depends on the Excel version you work with.