populating one cell (selecting from drop-down options) based on content of another cell in sheet

Guy Price

Hi there, first question posted on the Smartsheet Community, here we go...

I'm trying to work out a formula/solution for automatically populating a cell (from a drop-down containing 5 geographic location options) based on the first three characters of a postcode (zip code) in another column (approx 150 postcodes).

For example, in the screenshot here, T23 is a Munster postcode, so I need to adjacent cell to select Munster from the drop-down.

My best option so far is a cumbersome IF THEN formula that includes all 150 postcodes, but I'm sure there must be a far more efficient way of doing it.

I have looked at so many formulas here int he community that my brain is now fully scrambled! Really appreciate any help and advice, thank you!

Paul Newcome

You would need to create a table that lists out all 150 postcodes in one column and their corresponding regions in another. From there you can use either a VLOOKUP or (the much preferred) INDEX/MATCH.