Execute text in cell as formula

Hi

I got an issue , where I have been trying to find a way how to execute text in cell as formula without using INDIRECT or to be able to make it smarter as it is in my screenshot .

I have a list with several options and when I choose one, I need to show different result and that result is combine with different cells which varies as well . Any idea how to make text in cell convert into formula , so I can match list number everytime to correct list cell and execute that cell for result. What I need is just idea how to avoid using INDIRECT or use it it smarter so I don't need to write INDIRECT for every cell. Thank you for any suggestion.

Capture.JPG

I would need more information. Right row, it looks like column J1 is just the formula
=IF(F1="","",F1&G1&H1)
copied down to J8. Then, cell C1 is the formula:
=VLOOKUP(A1,$E$1:$J$8,6,FALSE)

Update.

What I want to shorten this ridiculous long formula, because I have 24 option in my list and my result combination for one list is sometime combination of 6 cell and I need flexibility to rewrite just cell and convert into formula and insert instead INDIRECT

=IF($A$2=1,INDIRECT(F2)&INDIRECT(G2)&INDIRECT(H2),IF($A$2=4,INDIRECT(F5)&INDIRECT(G5)&INDIRECT(H5),IF($A$2=7,INDIRECT(F8)&INDIRECT(G8)&INDIRECT(H8))))

Capture.JPG

[j1] =f1&g1&h1
[j2] =f1&g1&h1
[j4] =f4&g4&h4
[j5] =f4&g4&h4
[j7] =f7&g7&h7
[j8] =f7&g7&h7

[c1] =index($j$1:$j$8,$a$2)

OK this is good but it gives just cell value not executes the formula in cell with final value . What I need is result 123, abc or 11\1122\2233\33. Anyway thanks for something new

Actually, my formula gives result 123, abc, or 11\1122\2233\33.

Sorry could you maybe make a screenshot from excel how it is written or just mail me that excel to my email kepo444 gmail.com please so I can have a quick look , I got a problem replicate it on my own. Thanks

Originally Posted by Kepo444

Sorry could you maybe make a screenshot from excel how it is written or just mail me that excel to my email kepo444 gmail.com please so I can have a quick look , I got a problem replicate it on my own. Thanks

Here you go!

Thanks but maybe I wasn't so clear about what I need . I just learn how to make attachment here is my excel . What I need is if is any way how to execute text in cell so for example I got in cell F1&G1&H1 and result will be in A1 so it will be 123 and I decided that I want to change it so I rewrite text in cell to point it into
F4&G1&H1 so result will change in A1 into a23 . Is any way how to do it without using INDIRECT for any cell.

How about this, I made it semicolon delimited.

I really appreciate your effort man , but that your way is even harder to write and understand that my , but you need to have a skill to be able to write formula like that How I said I got like 22 lists , so that is no way , you can write that for 22 list item, I need something easier, where part of the code will be in cell so I can rewrite that part anytime and execute in combination with formula with dependencies which list i pick. So I am going to have if(list1,If(list2,If(list3,If(list4)))) and when I rewrite text in cell which is list1 it will be change automatically.

Originally Posted by Kepo444

I really appreciate your effort man , but that your way is even harder to write and understand that my , but you need to have a skill to be able to write formula like that How I said I got like 22 lists , so that is no way , you can write that for 22 list item, I need something easier, where part of the code will be in cell so I can rewrite that part anytime and execute in combination with formula with dependencies which list i pick. So I am going to have if(list1,If(list2,If(list3,If(list4)))) and when I rewrite text in cell which is list1 it will be change automatically.

Explain what you actually want, and we can help you do it. We can only provide solutions to what you tell us. What do you mean you have 22 list items? Give us a better example, and we can show you how to get what you want.

OK I will try to explain it once again with new excel. Hope so will be more clearer from that. What I am really trying to achieve is have a result which I can change with text change in cell not in formula and able to apply it for all line in list below .

Capture.JPG

Hi

I see it now. I have been playing with this and this is exactly what I need it =choose . Thank you sir.

As well very interesting approach into solve this challenge and thanks for sharing. I guess there is no direct way how to execute cell value as formula or part of the formula. Anyway thank you for all your reply , I can move forward with this new knowledge and learnt few new things. Really appreciate.

So after playing with this I was able to find exactly what I was looking for. I have created in Name Manager new compartment for every case I will be needed and use evaluate =EVALUATE(Reports!$C$12) , =EVALUATE(Reports!$C$19), =EVALUATE(Reports!$C$26), etc and =CHOOSE(_listNumber,DM_ISOM_001,DM_ISOM_002,DM_ISOM_003,DM_ISOM_004). So now when I update cell it will update my result whatever I at that moment need. Thank you

Capture.JPG