Formula

[Lisa Simpson]

I need a formula that can search a column for a word, which will then search
the row for a value.

I.e. Column C to find word 'text' which will then search the row for a
value of >4

Thanks

 

[T. Valko]

Try this array formula** :

A1 = text lookup value

=INDEX(D2:G12,MATCH(A1,C2:C12,0),MATCH(TRUE,INDEX(D2:G12,MATCH(A1,C2:C12,0),0)>4,0))

That will return the first value from left to right in the corresponding row
that meets the criteria.

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.