can an expert help with this problem please.
I need to lookup column P in my current sheet and then find this in my sheet called Static. [I have called the data range in the sheet static Agebands]
column A in Agebands contains the name of various countries, column E contains formulas which is what I would like my vlookup to return.
so an normal vlookup i.e. =VLOOKUP(P9,AgeBands,4,0) would return >45 but what I need it to return is the formula in E which is =IF(S2<=30,Static!$B$7,IF(Spain!S2<45,Static!$C$7,IF(Spain!S2>45,Static!$D$7)))
can anyone help?