maybe some more info on how the data you're looking up is laid out.

--


Gary


"mickn74" wrote in message
...
I want to key in a number to return multiple responses. Im using a look up a
table on a secondary sheet yet the number has multiple responses. What
formula do I use or where in help is it. I found look up One value and return
multiple corresponding Values yet I need to return multiple worlds not
numerical values.

Can anoyone point me in the right direction

Cheers

Michael