Find a number then offset

  • Thread starter Thread starter Barneypo
  • Start date Start date
B

Barneypo

In cell Z34, how do I find a number from 1 to 12 (say 9 which could
be anywhere in column B5:B30) then OFFSET from that to find the result
to put in Z34?

e.g."=FIND(9) in B5:B30 then OFFSET(9,20,2)"

Thanks,

Barney
 
Thanks Bob. I don't think I explained very well. Perhaps you could
look at the spreadsheet at http://jaxsi.org/OCN_2010.xls.

In cell BL11, I want a formula that will find the value of cell BB11
in the range C10:C90. Then drop down 2 rows and right 26 columns and
return the value in AC12. In this case it is 24.

I will need similar formulas in BL12 :BL22. As you can see the values
in C10:C90 are the numbers 1-12 but they will be in random locations
in the range C10:C90.

Thanks again,

Barney
 
How about this?

=INDEX($AC$10:$AC$90,MATCH($BB11,$C$10:$C$90,0)+2)

--

HTH

Bob

Thanks Bob. I don't think I explained very well. Perhaps you could
look at the spreadsheet at http://jaxsi.org/OCN_2010.xls.

In cell BL11, I want a formula that will find the value of cell BB11
in the range C10:C90. Then drop down 2 rows and right 26 columns and
return the value in AC12. In this case it is 24.

I will need similar formulas in BL12 :BL22. As you can see the values
in C10:C90 are the numbers 1-12 but they will be in random locations
in the range C10:C90.

Thanks again,

Barney
 
Back
Top