Find linked excel document based on value

Hi I want excel to look up a specific value in an excel document but I want it to do so based on the value of p2

i.e if p2= "apples" I want it to look up

='C:\folder\folder\[apples.xlsx]Sheet1'!$D$7

if p2 = "pears"

='C:\folder\folder\[pears.xlsx]Sheet1'!$D$7

is this possible

many thanks

Dave

Hi many thanks, however I'm getting reference error?