Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jim Jim is offline
external usenet poster
 
Posts: 615
Default Adding in an 'IF' to existing formula

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 905
Default Adding in an 'IF' to existing formula

"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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,520
Default Adding in an 'IF' to existing formula

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   Report Post  
Posted to microsoft.public.excel.misc
Jim Jim is offline
external usenet poster
 
Posts: 615
Default Adding in an 'IF' to existing formula

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
adding function to an existing formula chickenita Excel Worksheet Functions 2 August 6th 08 07:36 PM
adding a round function to an existing formula Deb Paiement Excel Worksheet Functions 2 July 10th 08 09:28 PM
Adding to an existing formula JPS Excel Worksheet Functions 2 April 17th 08 04:04 PM
adding formula to existing database Country Boy Excel Worksheet Functions 3 September 5th 05 03:50 PM
What is the formula for adding a number of days to an existing dat Ivan Excel Worksheet Functions 1 May 4th 05 03:00 AM


All times are GMT +1. The time now is 10:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"