Jagwarman
asked on
kup that will return a formula
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<4 5,Static!$ C$7,IF(Spa in!S2>45,S tatic!$D$7 )))
can anyone help?
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(
can anyone help?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I take that back, I have worked out how to make it perform the calculation.
Many thanks Phillip.
Many thanks Phillip.
ASKER
Hmm! maybe what I was hoping for won't work. Your code does get the formula, it picks up the formula from the static sheet but instead of returning the answer >45 it shows the formula
=IF(S2<=30,Static!$B$7,IF(
in the cell.
So I guess it's not possible to get it to put out the result rather than the formula ??