hybrid formula H&Vlookup????

[John Smith]

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.

 

[L. Howard Kittle]

Try this.

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

HTH
Regards,
Howard

 

[John Smith]

Try this.

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

HTH
Regards,
Howard








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

 

[Max]

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]

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





- Show quoted text -

Perfect! Thanks.

 

[Max]

Welcome, glad to hear
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik