Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
"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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
adding function to an existing formula | Excel Worksheet Functions | |||
adding a round function to an existing formula | Excel Worksheet Functions | |||
Adding to an existing formula | Excel Worksheet Functions | |||
adding formula to existing database | Excel Worksheet Functions | |||
What is the formula for adding a number of days to an existing dat | Excel Worksheet Functions |