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.

--
Biff
Microsoft Excel MVP


"Lisa Simpson" <Lisa wrote in message
...
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