Lookup

S

Scott W

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
 
B

bj

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

Toppers

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.
 
A

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
 
Top