formula help

New Contributor



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 Replies
best response confirmed by Riny_van_Eekelen (Respected Contributor)


Does this do what you want?


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

Thank you Hans, appreciate it. This worked