Enter Value of cell G2 into C2 if cell E2 contains "In"

[edwinkbell]

I need to enter Value of cell "G2" into cell "C2" if cell "E2" contains the word "In".
If it does not C2 remains blank.

Can someone please help?

Thanks

[teylyn]

In cell C2 put the following formula:

=IF(ISNUMBER(SEARCH("in",E2,1)),G2,"")

The SEARCH function searches for a text ("in") in cell E2 and will return the position of the text in the string as a number. If the text is not found in E2, the SEARCH funciton will return #VALUE.

The ISNUMBER function checks if SEARCH returns a number. If so, the search text was found in E2, ISNUMBER evaluates to TRUE, and whatever is displayed in G2 will now also be displayed in C2.

If the SEARCH does not return a number, the ISNUMBER function evaluates to FALSE and a blank will be shown in C2

HTH

[edwinkbell]

Thanks Teylyn,
That solution worked just as I needed it to.
I also have another problem that I could use soem assistance with, if you are up for the challenge? I posted it a few days ago and have not gotten any responses, maybe you could take a look and give me some advise.

The link to my post titles "Multiple Timesheets, auto fill from data sheet" :
http://www.excelforum.com/excel-work...ata-sheet.html

Please let me know if this is possible or how I can accomplish it.

Thanks again for your help! I really, really, really appreciate it...

E