# Problem with CHOOSE function

#### SGH

##### Board Regular
I have a CHOOSE formula in
H19 =CHOOSE(K19,L19,M19)
K19 displays the value 1
L19 displays the value 205
M19 displays the value 204

the result of the formula in H19 diplays 0
But when you enter the formula using the funtion wizard it says the answer is 205, I think i'ts to do with the format of the cells but these are all set to general, any ideas ?

### Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

#### onlyadrafter

##### Well-known Member
Hello,

This won't solve your problem, but the only way i get a 0 is to have no text in cell L19. I have created the CHOOSE formula several ways and always get 205.

Are you sure you chose the correct cell when not using the Wizard?

#### SGH

##### Board Regular
I did use the wizard & I still get a 0

#### PaddyD

##### MrExcel MVP
as per onlyadrafter's reply, the format of the cells shouldn't make a difference - describe exactly what you've done etc...

#### SGH

##### Board Regular
The cells K19, L19 & M19 are the results of other formula.

H19 was blank, I used the Formula wizard & picked the CHOOSE function
which whilst still in the wizard gave the correct answer of 205, I click OK to exit the Formula wizard & the cell displays '0'.

#### PaddyD

##### MrExcel MVP
weird - & there's really nothing else going on? what happens if you try the formula in another cell?

#### Aladin Akyurek

##### MrExcel MVP
What do you get with...

=INDEX(L19:M19,K19) ?

#### SGH

##### Board Regular
Again, I get the correct answer through Formula Wizard but click OK to exit it & I get 0 again !

#### Aladin Akyurek

##### MrExcel MVP
SGH said:
Again, I get the correct answer through Formula Wizard but click OK to exit it & I get 0 again !

What do you get with...

=CHOOSE(--K19,L19,M19) ?

#### SGH

##### Board Regular
Same again I'm afraid , 0.

Replies
3
Views
750
Replies
17
Views
2K
Replies
5
Views
447
Replies
4
Views
425
Replies
1
Views
831

Threads
1,181,607
Messages
5,930,884
Members
436,764
Latest member
avalladarez

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back