Lookup

[Guest]

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

 

[Guest]

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

 

[Guest]

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.

 

[andy duncan]

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

Have you got an example ?

Andy