oFFSET
 

Help,
I have a huge spreadsheet exported from a different source into excel.

Column B
Example:
Col B Col J
57 (60C) 5
61 (60C) 3
62 (60C) 2
63 (60C) 2
70 (60C) 4

Every time after the last 60C on column b there a "Service Area Total" word
5 Rows below that and the total that I need is on col j or 9 col over to the right

My question is
is there a way for a formula to find the last 60C Go down 5 rows and give the number on column J or 9 columns to the right??

Thank you hope this makes sense.

oFFSET
 

Hi Jaime,

Am Wed, 13 Jan 2016 11:38:56 -0800 (PST) schrieb
:

Example:
Col B Col J
57 (60C) 5
61 (60C) 3
62 (60C) 2
63 (60C) 2
70 (60C) 4

Every time after the last 60C on column b there a "Service Area Total" word
5 Rows below that and the total that I need is on col j or 9 col over to the right

your explanation is not really clear but I hope I understood it
correctly.
Try:
=INDIRECT("J"&MATCH("*"&"(60C)",B:B,-1)+5)


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional