SOLVED

formula help

New Contributor

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

@Atli-369 

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