Thanks, My example was not a good one because I am using multiple sheets in the workbook. I think that I have found another way to do it but if not I'll post again.
I know how to use VLOOKUP to look up a number or text string and insert it into a cell. What I want to know is how to look up a function and have it work in the cell it is inserted into.
EXAMPLE:
A B C D E
1 a (E1+D1) 3 6
2 b (E*D)
3
4 a
In cell B4 I want to put...
