formula lookup

[Sharp]

Hi,

i have 2 worksheets. On one i have a list of formulas with reference codes next to them. On the other i want the user to be able to type the refernce code in one cell and bring back the formula in another...is this possible. If i use a vlookup, it just brings back the result of the formula, rather than the actual formula

thanks

[juz4kix]

convert the formula data to text. it will show the formula in your results. if you want it to calculate in your new sheet, you'd probably have to generate somekind of macro for that.

[Portuga]

One way to do this is to use a user defined function and a helper column.
Insert the following function in a module:

Please Login or Register  to view this content.

You can now create the helper column in the sheet and type =Showformula( referencing the column that have the formula and drag down.

Use a vlookup to this column and return the formula.