## Using CHOOSE() with Range References in Excel FormulasLast reviewed: October 31, 1994 |

The information in this article applies to: - Microsoft Excel for Windows, version 2,x, 3.0, 4.0, 4.0a
Summary: Microsoft Excel returns incorrect results when you use ranges for the value argument with CHOOSE(), as in the following example: =CHOOSE(1,A1:A4,B1:B4,C1:C4) Using ranges causes Microsoft Excel to return either #VALUE or a single value that can vary depending on the location of the equation. To obtain the correct results, do one of the following: - Enter the formula as an array formula using CTRL+SHIFT+ENTER for CHOOSE() to return the correct results with ranges.
- Enter the equation as an array formula in a single cell for Microsoft Excel to return the first value of the range based on the index_number.
When you highlight a range and enter the equation as an array formula, Excel returns values from the selected range to fill the cells or #N/A if the highlighted area is larger than the range specified in CHOOSE(). |

KBCategory: kbother Last reviewed: October 31, 1994 |