VLOOKUP with a formula

[shleypie]

I am using the VLOOKUP function to pull data from my index page to another sheet. I have a formula i needed to pull from the cell in my VLOOKUP function but the formula is not carrying over. Is it possible to get the folrmula from the cell to carry over? Do i need to use a different function?
Thanks

[Jonmo1]

Sorry, that doesn't really make any sense.

Can you post an example?

[RS15]

The only way I could think to do this for you would be to make a custom function in VBA:

Please Login or Register  to view this content.

That function =TEXTFORMULA(cell) will return the formula as a string.

I coupled that with the index/match function to do what you want:

Please Login or Register  to view this content.

where the array you want to match to is in A1:A5 and the formulas you are trying to show are in B1:B5 and the value you want to match is in D1.

If you need more explanation let me know. Sorry it's not vlookup, I can't even remember how to use that formula as index/match is a much more robust and flexible option.