Another alternative is to use a User Defined Function.

How do you want to display those results? In one cell, but separated by
commas? In separate cells???

If you want a single cell:

http://groups.google.co.uk/group/mic...28f1ba868980a8

or

http://snipurl.com/24yfb (first post in the thread)


If you wanted separate cells (horizontal or veritical), take a look he

http://groups.google.co.uk/group/mic...467b485b0a4f4d

or

http://snipurl.com/24yf3

If you're new to macros:

Debra Dalgleish has some notes how to implement macros he
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)

Dave Peterson wrote:

Check out Chip Pearson's site:
http://www.cpearson.com/Excel/TablesAndLookups.aspx

Look for "Arbitrary Lookups"

wrote:

<<snipped
Thank you for the response. That is what I feared. I am unable to
manipulate the layout of the table, as it is a canned report that is
spit out of an online system, and we would like our users to as little
manual manipulation as possible. Do you know of any other formulas
that could help with this?

--

Dave Peterson

--

Dave Peterson