Alternative to “too long” LOOKUP formula

Asked By 7060 points N/A Posted on -

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.

Thanks, Martin

Answered By 0 points N/A #84638

Alternative to “too long” LOOKUP formula


Good day Mr. Martin,

On the subject of your problem, about Microsoft Excel, things that I can advise to you are; upgrade your Microsoft Excel to a newer version, newer version is more easy to use than the old one and its also have a bunch of good features which can benefit your time. But if you insist to use the old one, then click the help button on the menu bar, the rest will be the instructions.

Hope this can help you.

Login/Register to Answer

Related Questions