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