Nested Index Match

I have a unique reference number in Sheet1 that currently has an index match formula from another data set in Sheet2. This works fine like so:

=INDEX(Produce!$M$2:$M$2000,MATCH($E2,Produce!$F$2:$F$2000,0))

However the data being retrieved is unnecessarily detailed and needs to be categorised. For example I'm bringing back apples, bananas and oranges - when I want to bring back "Fruits".

I don't want to edit the data in Sheet2 so I have Sheet3 which categorises the data from Sheet2. ie.

Apple Fruit
Carrot Veg
Orange Fruit
Pear Fruit
Pea Veg

What I want to acheive is a formula that will see the URN, identify it refers to an apple, then bring back a result of Fruit.

I have hundreds on items that fit into 10 categories. I don't want to mess around with the data in Sheet2. Thanks.

Try something on these lines

=INDEX(Sheet3!B:B,MATCH(INDEX(Produce!$M$2:$M$2000,MATCH($E2,Produce!$F$2:$F$2000,0)),Sheet3!A:A,0))

where in Sheet 3 col A has Apple, Carrot etc. listed and Col B has fruit , Beg against each of these