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