Forum Discussion
How to use multiple If statements across many variants (Array)??
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 cor...
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.