Vlookup with multiple conditions

[cambrus]

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

 

[Peo Sjoblom]

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

entered with ctrl + shift & enter