I have a number of sheets within a workbook each of which are assigned to a specific person for weekly data entry. I have set up another sheet which gives me an overview of the week, 2 columns of 5 cells each per day into which data is taken from the persons sheet if particular words are entered. So far I've used this and achieved reasonable results (although the &CHAR(10) is not functioning - another problem ).

&IF(OR(Monday!G16="small")," Jayne "&Monday!G19,"") &CHAR(10) &IF(OR(Monday!H16="small")," Alex "&Monday!H19,"") &CHAR(10) &IF(OR(Monday!I16="small")," Tom "&Monday!I19,"")

&IF(OR(Monday!G16="tall")," Jayne "&Monday!G19,"") &CHAR(10) &IF(OR(Monday!H16="tall")," Alex "&Monday!H19,"") &CHAR(10) &IF(OR(Monday!I16=" tall")," Tom "&Monday!I19,"")

However, I'd like to tweak it so that the formula allows recognition of 'tall' or 'small' even when they are both entered in the originating cell (and also not character sensitive), rather than having to be the only word entered. I tried using * but it threw a wobbly!

Any ideas? There's probably a simple answer, but I'm just starting using formulae so I don't know all the tricks.

Thanks