Finding text in cells and return a value from other cell

[damaple]

here's the problem i have:

i have 5 tables, 1 for each day.
in specific column i have the "discribe a problem" area.
in that column i want to find a certain text and if the text was found it will show the date of the day that located in other cell of the table.
and i want to do that for all the 5 days but if it find the text in day 1 it will show the date of day 1, and if in day 2, then date of day 2. and all this formula to be in one cell (because we don't know which day will have the text im looking for) and in other sheet.

iv'e tried with any function you could imagine: find, lookup, vlookup, search, index, match, find
and using them together like index and match. and i couldn't figure how to solve this.

Thank you for your help

[Ursul]

Please upload an example - it's make life so much easier for all

[damaple]

Ok

sheet 1:
here is 3 days (just to show the idea, dont need the whole week).
in colunm c there is the text i need to find.
if the text is blah, the date of the day (with the blah) will be in F3 in sheet 2
jhejd3yvz0cn.jpg

sheet 2:
dlgzntkmywoz.jpg

in this example it will be 02.10.2013

[Fotis1991]

Pictures are nice but no one can works on it!

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[damaple]

i didn't know how to make the data desensitize.

look at what i've done.

in "sheet with data" there's 3 tables for 3 days in a week and 3 weeks.
in "sheet of weeks" there's table with all the weeks so far and below them the date.
now, in that date cell in "sheet of weeks" i need the formula. the condition for the date in week 1 is if in week 1 (in the first sheet) there's an x in the problem column if so, it copys the date of the day.
in week 2 there is no "x" so in the date cell its "none".
and do this for all the weeks.


i hope you understand.

[Fotis1991]

Using this formula

=IFERROR(INDEX('sheet with data'!$H$2:$H$21;MATCH("x";'sheet with data'!$I$3:$I$21;0));"none")

You get your results but you need to use the next to your data column filling with your dates..

[damaple]

Thanks! it works!

[Fotis1991]

You are welcome and thanks for the feedback.

As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED,as per Forum Rule #9. Thank you.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.