How to match a row value and column value and return a matched cell as result in excel?

I have a table with data distributed like in the picture below.

I would like to match each fruit vendor to the market only if they have a fruit.

Something like this, Could someone please help me? I have managed to match the row and column successfully with IF and AND. However, since some columns are missing values the match becomes ineffective. Please note that the columns and rows are already in place, only the correct fruit name is needed.