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