Execute a statement if certain criteria is met

  • Thread starter Thread starter sportjunkie42
  • Start date Start date
S

sportjunkie42

I've got a formula that pulls data from different worksheets. However, I'd like to edit this some how to only do this if G14 > F14. Suggestions?


=CONCATENATE(
VLOOKUP("Attachment Security",'Auto - Windows'!$A$4:$I$75,9,FALSE),CHAR(10),
VLOOKUP("Attachment Security",'Manual - Windows'!$A$4:$I$63,9, FALSE),CHAR(10),
VLOOKUP("Affix Signatures",'Manual - Windows'!$A$4:$I$63,9, FALSE)
)
 
Hi,

Am Tue, 1 Jul 2014 19:27:44 -0700 (PDT) schrieb (e-mail address removed):
=CONCATENATE(
VLOOKUP("Attachment Security",'Auto - Windows'!$A$4:$I$75,9,FALSE),CHAR(10),
VLOOKUP("Attachment Security",'Manual - Windows'!$A$4:$I$63,9, FALSE),CHAR(10),
VLOOKUP("Affix Signatures",'Manual - Windows'!$A$4:$I$63,9, FALSE)
)
Click to expand...

try:
=IF(G14>F14,CONCATENATE(VLOOKUP("Attachment Security",'Auto - Windows'!$A$4:$I$75,9,FALSE),CHAR(10),VLOOKUP("Attachment Security",'Manual - Windows'!$A$4:$I$63,9, FALSE),CHAR(10),VLOOKUP("Affix Signatures",'Manual - Windows'!$A$4:$I$63,9, FALSE)),"")


Regards
Claus B.
 
Back
Top