I'm having trouble grouping a couple of formulas together, could anyone
please advise? Thanks

Originally i had
IF(B$7="","",VLOOKUP(B$7,'SHOP1'!B:AC,6,FALSE))
which returned the desired result
but now i am trying to add in a factor that only pulls that result through
if R7=Apples. I have the below formula but that is still pulling through the
value from column 6 even though R7 does not=Apples?

IF(B$7="",(IF(R$7="APPLES","","")),VLOOKUP(B$7,'SH OP1'!B:AC,6,FALSE))

Can anyone point out where I am falling down with this one?

--
Jim