Vlookup returning formula

[Juran]

HI,

I have a workbook listing part descriptions. Some cells have just a numeric value and some have some formula.

When I use Vlookup, I just get the value on the cell with formula. Is there a way to get the formula with the Vlookup?

Thank you.

Juran

[shg]

No, there isn't. There may be another way to do what you're trying to do, though.

[NBVC]

Not with Native Excel functionality...

you can download and install a free addin from here Morefunc.xll and use a formula such as:

=FORMULATEXT(INDEX(A1:H4,MATCH(X1,A1:A4,0),8))

where your table is in A1:H4 and you are matching X1 to A1:A4 to get formulas located in H1:H4

adjust references to suit.

[Juran]

NBVC,

Thank you for your reply.

I tried using the formula, but it is returnig #ref.

Any suggestion?

Thank you.

Juran

[NBVC]

Did you install the addin successfully?

[Juran]

NBVC,

Yes it was installed successfully.

I tried just the Formulatext and worked fine.

Juran

[NBVC]

Great.

Please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[Juran]

NBVC,

What I meant was the the addin was installed successfully.

When I tried your formula, I got #ref.

To make sure that I installed the Addin successfully, I use =formulatext() and worked.

I maybe doing something wrong.

Juran

[Juran]

NBVC,

I tried the formula again at hoem and worked. Probably at work I made some syntex error. I will check tomorrow.

Again thank for your help. I will close the thread.

Juran