Alternative to “too long” LOOKUP formula

Asked By anonymous 7060 points N/A Posted on - 10/25/2012

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

• Status: Open
• Question Views: 643
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Anonymous questions

Answered By Downer halt 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.

About Downer halt

Questions
0

Answers
31

Best Answers
8

• Vote Up 0 Vote Down

• Posted on - 12/12/2012
• Question Category: Anonymous questions