• Status: Solved
• Priority: Medium
• Security: Public
• Views: 90

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?
0
Jagwarman
• 2
1 Solution

Director, Practice Manager and Computing ConsultantCommented:
Use =FormulaInE(match(P9,Static!A:A,0))

And in a VBA module

Function FormulaInE(introw)
FormulaInE = sheets("Static").cells(introw,5).Formula
End Function
0

Author Commented:
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 ??
0

Author Commented:
I take that back, I have worked out how to make it perform the calculation.

Many thanks Phillip.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Featured Post

• 2
Tackle projects and never again get stuck behind a technical roadblock.