Alternative to “too long” LOOKUP formula
Excel 2003 – I have a spreadsheet where a specific cell (A1) is set with data validation to a list of 22 location names. I need another cell (A2) where I had attempted to create a LOOKUP (against A1) formula to return full delivery addresses dependent of the location name selected in cell A1.
Formula works but only for 6 or so locations. Any alternative to this requirement (without using Macro) would be greatly appreciated. Workbook is a template used by many people and needs to be "simple" for user, even if that requires a bit of work to set it up in the first place.