# September 29, 2023: VLOOKUP and Find and Replace! ## VLOOKUP Mito now supports the formula VLOOKUP - making referencing data across sheets easier than ever. ## Find and Replace With our new find and replace functionality, navigating a Mitosheet is effortless! All you need to do is press command + f or press the "Search" button in the toolbar, and start typing. The new search functionality also includes the ability to replace your search term - both in the entire sheet and in the selected columns. #### Other New Features 1. Code optimization is now open source. 2. Dynamic range imports for Excel files now supports taking all rows until a specified number of consecutive empty rows are found. 3. Added the ability to change custom imports after the initial import. #### Bug Fixes * Fix the behavior of the cell editor so that pressing escape anywhere in the mitosheet closes the cell editor. --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.trymito.io/misc/release-notes/september-29-2023-vlookup-and-find-and-replace.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.