View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
HA14 HA14 is offline
external usenet poster
 
Posts: 9
Default Lookup and return value 12 rows below

I am trying to find a formula to lookup in a table and return the
value to the right 12 rows below. In the example below my search value
is 02-2007 and I would like to return the value 36.000 which is 12
rows below next to 02-2008.

search value 02-2007

01-2007 10.000
02-2007 12.000
03-2007 14.000
04-2007 16.000
05-2007 18.000
06-2007 20.000
07-2007 22.000
08-2007 24.000
09-2007 26.000
10-2007 28.000
11-2007 30.000
12-2007 32.000
01-2008 34.000
02-2008 36.000

result 36.000

Can someone help me?

Thanks
HA14