Hi all, I understand how the SUMIFS formula works. I need something that does the same, only the formula doesn't return a sum it just returns a cell value - as the colum usually used to "sum" in the SUMIFS formula actually contains text not numbers.

So for instance I would want the criteria to say, if cells in B:B = 2, and cells in C:C = 10 then return cell A - which may be "chicken".

Is this possible in excel?