Link to home
Start Free TrialLog in
Avatar of Jagwarman
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<45,Static!$C$7,IF(Spain!S2>45,Static!$D$7)))

can anyone help?
ASKER CERTIFIED SOLUTION
Avatar of Phillip Burton
Phillip Burton

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Jagwarman
Jagwarman

ASKER

Hi Phillip,

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(Spain!S2<45,Static!$C$7,IF(Spain!S2>45,Static!$D$7)))
in the cell.

So I guess it's not possible to get it to put out the result rather than the formula ??
I take that back, I have worked out how to make it perform the calculation.

Many thanks Phillip.