I need to find a value in a certain row and return a value from same
row. I can't use vlookup because the lookup value can be with in any
colunm within a certain range. And the cell I have the formula in has
to be looking for the value in that same row.


111121411111111 =find "2" within this row and return value two
cells to the right of "2"
111111215111111
112111111111111
111111111129111
111111121311111


Thanks.