Breakdown a formula

I have inherited a spreadsheet with a large number of Vlookups. I would like to break down the formula to its various elements.

For example a cell with the =VLOOKUP(D4,A4:B12,2,FALSE) would be broken down in a new list to:

Lookup value: D4
Table array: A4:B12
Col index num: 2
range lookup: false

Is this possible, would VBA be any use.

So far I have used find and replace (ctrl H) to replace the = with $$$= so that the formula is text format. But i am sure if this is the right thing to do or where to go after that.

Let me know if you want any further information

Thanks

Lucky_git

Can you explain what you are trying to achieve?

Hi,

thanks for getting back,

The ultimate aim would be to use the various elements in different formulas. As i have so many formulas and all reference to different places I don't want to have to create the formulas manually. I was hoping that there may be a quicker way out there somewhere.

Lucky_git

I would like to use the range that is currently being used in the Vlookup formula, and then use it in anouther formula.

For example =VLOOKUP(D4,A4:B12,2,FALSE) uses the range A4:B12 <------ the spreadsheet already has this formula in it.

I would then like to create a new formula with this range ie =Sumif(A4:B12,">15")

If i can get the various elements out i guess i could use the Indirect function to obtain the above formula.

Sorry if i am being unclear, I'm a bit over whelmed by this spreadsheet.

Why not post a representative sample workbook? I don't see the imperative for this, and even if you use a named range you still have to type the formula each time.

Okay, thanks for your help so far. I'll draw up a spreadsheet with what i would like to happen and get back.

Thanks again

Lucky_git