Get Cell With Value In Array That Contain Both Blank And Value?

How to get the one with value in an array that contain both blank and value in a cell?

I got a formula that's retrieving the type of an item that matches the number and name as shown:

The only problem is that some type might be blank.When Excel is returning the information, it would only show the first one in the array.How do I tell it only return the one with actual info?

Data sheet:
Number
Name
Type

In this case it will return {" ", "B", "B", " "}.

But because the cell can only show one value, it will only show " " (blank) as the final return value.Is there anyway to tell it to return "B" as final value? Right now, what I did is to sort the Type column to show non-blank first.