Uploaded February 2025 | Updated November 2026, 2 days ago
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: chandoo.org/wp/wp-content/uploads/2025/02/byrow-is-a-beast.xlsx
Learn more: 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)
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: chandoo.org/wp/wp-content/uploads/2025/02/byrow-is-a-beast.xlsx
Learn more: 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)










