I'm trying to do a Invoice thing where it calles information from a database of addresses. The basic way of doing this is
=INDEX(Addresses,$M$1,7)
But is there any way of having more than one index in one cell?
e.g. =INDEX(Addresses,$M$1,7)INDEX(Addresses,$M$1,6)
^^that doesn't work but you get the idea.I've tried putting each index in it's own brackets and putting a comma after each one, but neither methods are successful. Any ideas? btw I use Excel 2002.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic