Uploaded March 2025 | Updated September 2026, 1 week ago
If you're tired of using a separate vlookup formula for each column of data that you want to return, we're going to cover two ways to accomplish this-- first, the simplest way to accomplish this using the XLOOKUP formula, and then how to do this with the VLOOKUP formula along with some advanced tips and tricks.
If you're tired of using a separate vlookup formula for each column of data that you want to return, we're going to cover two ways to accomplish this-- first, the simplest way to accomplish this using the XLOOKUP formula, and then how to do this with the VLOOKUP formula along with some advanced tips and tricks.










