formula help

[Atli-369]

Hello,

I need help with the following formula:

=if(isnumber(search("put",F13)),E13,""), I have two worksheets and one of the worksheets has the info that I wish to copy and paste on another.  On worksheet #1("order worksheet") is this formula, on worksheet #2("In-Out dr sprds" is where the data is that I want looked at and copied to worksheet #1. How can I link this formula properly to accomplish this?

[#2 · Accepted solution]

@Atli-369 

Does this do what you want?

=IF(ISNUMBER(SEARCH("put",'In-Out dr sprds'!F13)),'In-Out dr sprds'!E13,"")

[#3]

Thank you Hans, appreciate it. This worked