Formulas as a result of Vlookup

I have a file where every day few hundred records are copied to column A.
I need to find a way to use different formula for different result of Vlookup (or index+match) formula.

Column A

Alfa

Beta

Charlie

Delta

etc

Table array for Vlookup

Alfa	Formula A
Beta	Formula B
Charlie	Formula C
Delta	Formula D
....	Formula X

Formulas are all different and there is too many of them to use nestled If.
What would be the most efficient way to solve it.
Thx

On limited testing:

=VLOOKUP(A2,$C$2:$D$5,2,0)

A2="Alpha"

C:D contains the lookup value and Formula

C2: "Alpha"
D2: with the formula "=SUM(G1:G10)" (without quotes)

C3: "Beta"
D3: =Average(G1:G10)

Originally Posted by JohnTopley

You cannot have both a value and a formula in a cell so what you require cannot be done with formulae: you will need VBA.

In addition you have the complication separating the data from the "code" which to be included in any formula.

Need to rethink!

It was just an example.
I have long strings from which I can extract parts (lets say parts are Alfa, Beta etc and I have them in new column(B)
Now when I have Alfa I need to extract last word from the string in column A, for Beta I need first word etc. I know how to make these formulas. I Could make nestled IF
If(B1="Alfa",extract last word from A1,if(B1="Beta",extract first word from A1,... Etc but it would be huge.
That's why I would like to use vlookup.

You need to post a sample workbook as each description of your problem differs. First you implied doing arithmetic, now you talk about extraction of text from a string.

You can waste a lot of "FREE" time given by respondents by not defining concisely what you require.

VBA solution

Please Login or Register  to view this content.