Here's an example

http://www.nwexcelsolutions.com/adva...ction_page.htm

look at number 6


--
Regards,

Peo Sjoblom


"aramancam" wrote in message
...
I'm trying to find a way to look up a single value in one column which has
multiple results in the next column.