Hello All-

Hoping someone can help me as I am getting quite frustrated! I am trying to find a formula that will allow me to populate a cell(s) with text based on more than one criteria (likely 2).

I have used SUMPRODUCT and SUMIFS however both of these work only if your "Sum_range" is numerical. I need a formula that is nearly identical to those however works for letters/words.

Example:

If the member name is Mary and member number is 4558, I need the letter "A" to populate in a particular cell of my spreadsheet (see attached chart).


Excel.jpg

Any help would be greatly appreciated!!

J