I am using look up to find values on a worksheet but I need to return more
than one value. Can thi sbe done with look up or should I be using some other
function?

Thanks


Scott

you will probably need to use some other function. More details are needed
to give you useful suggestions

"Scott W" wrote:

I am using look up to find values on a worksheet but I need to return more
than one value. Can thi sbe done with look up or should I be using some other
function?

Thanks


Scott

More detail is required but lookups (VLOOKUP etc) only return one value at a
time i.e if you have duplicate "keys" it will return the first.

"Scott W" wrote:

I am using look up to find values on a worksheet but I need to return more
than one value. Can thi sbe done with look up or should I be using some other
function?

Thanks


Scott

Scott,
would it not be easier to create one lookup, then a second lookup according
to that result ?

Have you got an example ?

Andy


"Scott W" wrote in message
...
I am using look up to find values on a worksheet but I need to return more
than one value. Can thi sbe done with look up or should I be using some
other
function?

Thanks


Scott