Return Text Based on Number Criterea

[glometeeb]

This should be really simple, and I just can't get it. I am very familiar with sumifs, but the issue is that my sum range is text and my criteria are numbers. So I always get a zero return.

=sumifs(A:A,B:B,C1) Need to return the ttt

A B C
ttt 1000 1000
rrr 1111
eee 2222

 

[Joe4]

You cannot use SUMIFS if trying to return a text value. That is only for summing numbers.

Try:

=INDEX(A:A,MATCH(C1,B:B))