Need to know how to make functions/formula work in LOOKUP...

[chrisophos]

Alright, I am making a decimal/binary/hex/octal convertor.
I have cell E3 set as a drop down box where you can pick from Decimal, Hexadecimal, Binary, and Octal. This is the type of number you will enter.
And then I have Cell E4 where you enter your own number.

Then I am going to have places for the results. I am trying to use LOOKUP to see what E3 is and then convert whatever the number in E4 is to the other types. So here is the code I am using to convert it to octal:

=LOOKUP(E3, {"Decimal","=DEC2OCT(E4)";"Hexadecimal","=HEX2OCT(E4)";"Binary","=BIN2OCT(E4)";"Octal","E4"})

The problem is that I can only get it to show =DEC2OCT(E4),E4,etc not the actual answer to it or the cell....is there anyway I can get it to show the answer?

[Excelenator]

You don't need LOOKUP you need IF statements or Select Case

With if statements you would cycle through each result like so

Please Login or Register  to view this content.

or with Select Case it would look like this

Please Login or Register  to view this content.

Alright, I am making a decimal/binary/hex/octal convertor.
I have cell E3 set as a drop down box where you can pick from Decimal, Hexadecimal, Binary, and Octal. This is the type of number you will enter.
And then I have Cell E4 where you enter your own number.

Then I am going to have places for the results. I am trying to use LOOKUP to see what E3 is and then convert whatever the number in E4 is to the other types. So here is the code I am using to convert it to octal:

=LOOKUP(E3, {"Decimal","=DEC2OCT(E4)";"Hexadecimal","=HEX2OCT(E4)";"Binary","=BIN2OCT(E4)";"Octal","E4"})

The problem is that I can only get it to show =DEC2OCT(E4),E4,etc not the actual answer to it or the cell....is there anyway I can get it to show the answer?

[daddylonglegs]

Try this formula

=CHOOSE(MATCH(E3,{"Decimal","Hexadecimal","Binary","Octal"},0),DEC2OCT(E4),HEX2OCT(E4),BIN2OCT(E4),E4)

[chrisophos]

Wow, thanks both of you. (Altho I didn't know where I was supposed to enter the first one) I got the second to work.