Garry

Thanks for you time more info

Sheet 1 entering the data of a post code 4000 on sheet 1, I want it to
return QCBD/QBMH and QBMH by typing in a single post code

Sheet 2 is the table listed below it needs to search the post code and
return multiple values say QCBD/QBMH and QBMH as there are 2 * 4000 postcode

4000 QCBD/QBMH Brisbane
4000 QBMH Spring Hill
4004 QBMH All suburbs
4005 QBMH All suburbs
4006 QBMH/QAGW All suburbs
4007 QSPN All suburbs
4008 QSPN All suburbs

I hope that sheds some light on it

Cheers,

Mick

"Gary Keramidas" wrote:

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