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

"Jim" wrote:
but now i am trying to add in a factor that only
pulls that result through if R7=Apples.
[....]
IF(B$7="",(IF(R$7="APPLES","","")),VLOOKUP(B$7,'SH OP1'!B:AC,6,FALSE))

Based on your English description, I think you want:

=IF(OR(B$7="", R$7<"APPLES"), "",
VLOOKUP(B$7,'SHOP1'!B:AC,6,FALSE))


----- original message -----

"Jim" wrote:
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

Try

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

--
Jacob


"Jim" wrote:

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

Thanks, sorted. Much apprecaited
--
Jim


"Jim" wrote:

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