How about a User Defined Function?
This returns a list separated by commas to a single cell.
http://groups.google.co.uk/groups?th...apeXSPAM.co m


Abhijeet wrote:

hi , i have data stored in excel as column a- Purchase order no column b-
Invoice no i want to query basis purchase order no & result should give
mutiple invoice no stored agst one purchase order no how do i do this using
lookup or something !

--

Dave Peterson