Vlookup with multiple conditions
 

Does anyone know of a function I can use to look up a cell based on multiple
conditions? I'm looking for something similar to the Sum(if((array-x=y),
array-z,0)) formula but it would return text and not a sum. Sort of a vlookup
with multiple conditions.

Thanks for your help.

Christine

=INDEX(Range_with_text_value,MATCH(1,(array-x=y)*(array-z=next_condition),0)
)

entered with ctrl + shift & enter


--

Regards,

Peo Sjoblom



"cambrus" wrote in message
...
Does anyone know of a function I can use to look up a cell based on
multiple
conditions? I'm looking for something similar to the Sum(if((array-x=y),
array-z,0)) formula but it would return text and not a sum. Sort of a
vlookup
with multiple conditions.

Thanks for your help.

Christine