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.

Try this.

=--MID(B1,FIND(2,B1)+2,1)

HTH
Regards,
Howard

"John Smith" wrote in message
...
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.

On Aug 20, 10:17*pm, "L. Howard Kittle" wrote:
Try this.

=--MID(B1,FIND(2,B1)+2,1)

HTH
Regards,
Howard

"John Smith" wrote in message

...



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.- Hide quoted text -

- Show quoted text -

Thanks. I wasn't clear on my example. Each of the numbers in the grid
above is in its own cell. A1:O1 is the top row range. Your idea works
great within the same cell. I need to find a value in one cell then
return a value in a different cell within the same row.

How about an index/match?
In P1: =INDEX(A1:O1,MATCH(2,A1:O1,0)+2)
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"John Smith" wrote:
.. Each of the numbers in the grid above is in its own cell.
A1:O1 is the top row range.

On Aug 20, 11:06*pm, Max wrote:
How about an index/match?
In P1: =INDEX(A1:O1,MATCH(2,A1:O1,0)+2)
Copy down
--
Max
Singaporehttp://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---



"John Smith" wrote:
.. Each of the numbers in the grid above is in its own cell.
A1:O1 is the top row range.- Hide quoted text -

- Show quoted text -

Perfect! Thanks.

Welcome, glad to hear
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"John Smith" wrote
Perfect! Thanks.