Make Nested Index Match formula return calculation instead of text VBA

[annab7]

Hello everyone i need help please!

I have the following formula : =IF($D9=0,"",($D9*INDEX(sheet1!E:G,MATCH($A$18,sheet1!A:A,0),MATCH("X",$N9:$P9,0)))+($E9-$D9)*INDEX(sheet1!H:J,MATCH($A$18,sheet1!A:A,0),MATCH("X",$N9:$P9,0)))

What i am trying is to find an evaluate vba way.. so that my functions returns values .

In other words formula be looking like this: IF($D9=0,"",(210*2.0089)+(210-211)*0.123

i ve been trying hard but i ve had no success

Thank you in advance

 

[StephenCrump]

Welcome to the Forum!

The question is not entirely clear, but perhaps?

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1
2
3
4
5
6
7
8		Value	Formula
9		421.992	=IF($D9=0,"",(210*2.0089)+(211-210)*0.123)	210	211									Blah	X	Blah
10
11
12
13
14
15
16
17
18	FindMe
Sheet2

Cell Formulas
Range	Formula
B9	B9	=IF($D9=0,"",($D9*INDEX(Sheet1!E:G,MATCH($A$18,Sheet1!A:A,0),MATCH("X",$N9:$P9,0)))+($E9-$D9)*INDEX(Sheet1!H:J,MATCH($A$18,Sheet1!A:A,0),MATCH("X",$N9:$P9,0)))
C9	C9	="=IF($D9=0,"""",(" & $D9 & "*" & INDEX(Sheet1!E:G,MATCH($A$18,Sheet1!A:A,0),MATCH("X",$N9:$P9,0)) & ")+(" & $E9 & "-" & $D9 & ")*" & INDEX(Sheet1!H:J,MATCH($A$18,Sheet1!A:A,0),MATCH("X",$N9:$P9,0)) & ")"

	A	B	C	D	E	F	G	H	I	J
1
2
3	FindMe				3	2.0089	7	11	0.123	17
4
Sheet1

 

[annab7]

Hello and thank you so much for your respond.
Yes i wasnt clear,sorry about that.
What i ment is : When user clicks on formula cell in formula bar appears the formula

What i need is to appear the formula with calculation results:

Thank you