C
CT
I created a formula with the following parameters:
=IF(B4=1,LOOKUP(B3,A5:A11,B5:B11),IFB4=2,LOOKUP
(B3,A5:A11,C5:C11),0)
B3 is a text operator formula of =B1&"."B2 so that I get a
text result that looks like a number 0.0.
The problem is that the text operator in the IF formula
above, results in an error message of #N/A.
Is there any way to combine two numbers by adding the "."
as a number?
Thanks,CT
=IF(B4=1,LOOKUP(B3,A5:A11,B5:B11),IFB4=2,LOOKUP
(B3,A5:A11,C5:C11),0)
B3 is a text operator formula of =B1&"."B2 so that I get a
text result that looks like a number 0.0.
The problem is that the text operator in the IF formula
above, results in an error message of #N/A.
Is there any way to combine two numbers by adding the "."
as a number?
Thanks,CT