look up and insert a function with VLOOKUP

Question

look up and insert a function with VLOOKUP

bob12bob (Civil/Environmental)

(OP)

11 Mar 04 19:56

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 (Civil/Environmental) · Answer 1 · 2004-03-11 19:57:06

RE: look up and insert a function with VLOOKUP

bob12bob (Civil/Environmental)

(OP)

11 Mar 04 19:57

Those formulas are in cells B1 and B2.

GregLocock (Automotive) · Answer 2 · 2004-03-11 20:12:39

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 (Civil/Environmental) · Answer 3 · 2004-03-13 10:41:47

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.

Come Join Us!

Posting Guidelines

look up and insert a function with VLOOKUP