Lookup function?

[DirtDawg]

I have an excel sheet with a lookup function
=LOOKUP(P2,M2:O2,$M$1:$O$1)

P= min
M2:O2 is costing
m1:01 Title

So what happens is that it prints the name of the lowest cost. But in some cases there are two prices that are the same. It only uses on name.

I would like to either have it take a priority name of my choice or Print both names into the Box, is this Possible?

Thanks in advance.

 

[xlbo]

Nope - not with a lookup function - will return one thing only - you would probably need a UDF to do this Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde

 

[Cresby]

You may be into macro territory or at least a more complex column/row structure. Maybe two columns of answers - or as many as needed!!