Excel has many new function, but this one is by far my favourite. In this video, learn why BYROW() should be your new best friend.
Sample file: https://chandoo.org/wp/wp-content/uploads/2025/02/byrow-is-a-beast.xlsx
Learn more: https://chandoo.org/wp/how-to-lookup-in-any-column-excel/
Video topics:
1) What is BYROW() formula in Excel and how to use it?
2) BYROW() with LAMBDA()
3) Using BYROW() to lookup in any column (advanced trick)