Lookup Function

[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

 

[RagDyer]

Try this in B3:

=--(B1&"."&B2)


HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


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