Execute a statement if certain criteria is met

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)
)
 
C

Claus Busch

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change Row Colour if certain criteria is met 2
Can I color a cell if a certain criteria is met? 4
excel 07 Dynamic copy certain cells if criteria is met onto next s 1
Can I auto move a row to the next worksheet if criteria is met 1
use of vlookup and IF functions on certain criteria 1
How to prevent listbox from being populated if certain criteria is met? 4
Do i need a Next or Loop statement ? 1
Why can't I execute a long INSERT SQL statement? 1

Top