Find the cell between the cross section of row and column

Request the formula to find the cross cell between row and column.

Example: Use the formula to find how many Orange that Justin ate.

Untitled.png

Hi,

Try below formula:

=INDEX($B$2:$E$7,MATCH(F1,$A$2:$A$7,0),MATCH(G1,$B$1:$E$1,0))

F1 HAS NAME, G1 HAS FRUIT.

Regards,