Question regarding lookup of value

Hi All,

Sorry if this might be a basic question, but I have tried Google for hours and haven't been able to crack this one.

So, I have a list of firm percentage values per year. These are not in the same order, so I can't use If and versions and I haven't been able to figure out how to crack this with using multiple lookup functions.

Basically, for every firm in my column, I want to retrieve the percentage value in the other table for a given year.

I have included a file that shows what I would like to do and think it should not be very hard for someone who knows how to tackle this.

All help is appreciated.

Assuming there will be only 1 percentage for each combination of firm and year, try

=SUMIFS($C$2:$C$5,$A$2:$A$5,E3,$B$2:$B$5,F3)

This will however return 0 if there is no match, instead of "".

To make it return "" instead, try
=IFERROR(1/(1/SUMIFS($C$2:$C$5,$A$2:$A$5,E3,$B$2:$B$5,F3)),"")

Thank you for your replies.
Would I be able to use index match for this as well? Some of my firms do not have perfect name matches as they contain LLC or differences in caps lock.