If row contains value, return x

[hypershock]

I'm working with an ancient greek lexicon,
and I'm trying to get all the parsing to line up.

I have a table with

	A	B	C	D	E
1	ἀκούω	I hear	present	first person	singular
2	ἀκούεις	you hear	second person	singular	present
3	ἄξω	I will lead	first person	future	singular

I want column F to display "present" if the row contains the word "present", "future" if it contains the word "future" etc

My problem is rather similar to http://www.excelforum.com/excel-prog...ign-value.html, but I'm trying to search the whole row rather than a single cell.

[alansidman]

Are you only concerned with Future and Present because you used the term etc and I'm not sure that you have more categories we don't know about.

[hypershock]

Yes there are more categories.

what I've got is

Please Login or Register  to view this content.

but that will quickly become awkward because Greek has more tenses than English. What I'm looking for is a shorter formula to achieve the same result

something like

Please Login or Register  to view this content.

but this one returns "#VALUE!"

[sktneer]

Based on your explanation in post#3, try this Array Formula. Since this is an array formula so you need to confirm it with Ctrl+Shift+Enter instead of just Enter. (i.e. after placing the formula in the cell, hold down the Ctrl+Shift and then press Enter.)

Please Login or Register  to view this content.

[hypershock]

That worked
Thanks

[sktneer]

You're welcome. Thanks for the feedback and rep.