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