Quote:
Originally Posted by Dave O
Rather than a conditional formula- by which I presume you mean an IF() formula- would a VLOOKUP() work instead? If you insert a column next to your city name, you could maintain a lookup table on a different tab. This would be much easier to maintain than a monstrously long IF() formula.
|
This could work, only problem is that when I looked VLookup in Excel it says the table must be in ascending order by default. Is this the reference table or the city column? If it's the city column then it won't do as our system automatically sorts entries by another field.