Formula

L

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

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.
 
Top