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

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?
  • 2
1 Solution
Phillip BurtonDirector, 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
JagwarmanAuthor 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
in the cell.

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

Many thanks Phillip.
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.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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