look up and insert a function with VLOOKUP

[bob12bob]

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 =VLOOKUP(A4, A1:B2,2,False) and have it return a value of 9. If I put a "b" in cell A4 I want it to return a value of 18.

If any one knows how to do this using functions in excel please reply. Thanks

 

[bob12bob]

Those formulas are in cells B1 and B2.

 

[GregLocock]

Um, what you have written seems to work once you have corrected the obvious mistake.

leastways, if i type a in a4 i get 9, and if i type b then i get 18?



Cheers

Greg Locock

 

[bob12bob]

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.