Can I create a formula to find a specific value within a group of.
 

I need to find an effficient way to find a specific value within a set.
Using the "OR" function is cumbersome and limiting.

depending on what it is you want to return a couple of functions spring to
mind, namely:
MATCH
LOOKUP
VLOOKUP
INDEX

.... if you'ld like to post back with more details we might be able to give a
better answer.

Cheers
JulieD

"nccpa13" wrote in message
...
I need to find an effficient way to find a specific value within a set.
Using the "OR" function is cumbersome and limiting.

I was having a problem with my vlookup function which would seem to be a
perfect solution. I have it figured out. Thanks JulieD,

Mark H
"JulieD" wrote:

depending on what it is you want to return a couple of functions spring to
mind, namely:
MATCH
LOOKUP
VLOOKUP
INDEX

.... if you'ld like to post back with more details we might be able to give a
better answer.

Cheers
JulieD

"nccpa13" wrote in message
...
I need to find an effficient way to find a specific value within a set.
Using the "OR" function is cumbersome and limiting.