Return value if date/value falls in range

[DavidvanR]

Hi everybody,

I hope someone can help me out here with the following issue. I would like to return the value D2 in J2 if the following condition is met J$1 >B2, J$1<C2. And I want to do the same for the values E2, F2, G, H2, I2 for the subsequent cells after J2. So if header J1 "1980" falls in the range of B2 and C2.

Var_ID Var_Startyear Var_Ending_year D) Var_Occupation_1_digit E) Var_Occupation_2_digit F) Var_Occupation_3_digit G) Var_Comp_TYPE H) Var_Comp_Sector I) Var_Comp_INDUSTRY J) 1980 K) 1980 L) 1980 M) 1980 O) 1980 P) 1980 1000001 2015 2016 2 24 241 5 4 42 1000002 #NULL! 4 43 431 #NULL! #NULL! #NULL! 1000003 1979 2000 9 99 999 4 4 41 1000004 #NULL! 3 33 332 6 1 13 1000005 2013 2016 3 33 331 6 4 41 1000006 2015 2016 6 61 610 6 1 11 1000007 2012 2016 1 19 199 6 4 41 1000008 2016 2016 6 63 630 6 1 11 1000009 #NULL! 1 12 121 6 1 13 1000010 #NULL! 3 33 331 6 4 42 1000011 2011 2016 3 33 331 6 4 42 1000012 #NULL! 3 33 331 6 4 41 1000013 2016 2016 9 99 999 6 4 42 1000014 2006 2016 2 24 241 6 4 42 1000015 2014 2016 2 24 241 6 2 21 1000016 #NULL! 2 24 241 6 4 42 1000017 2016 2016 2 24 241 6 1 13 1000018 1980 1981 3 33 331 6 4 41 <colgroup><col span="3"><col><col><col><col><col><col><col span="5"><col></colgroup><tbody> </tbody>

<tbody>
</tbody>

Thanks a lot in advanced!!

Kind regards, David

 

[DavidvanR]

So header year J1 is 1980 and should fall in the range of start year and end year. Then I would like to return the numerical values in Column J.