How do I look up a name in column A of sheet 1 and then return all the values in the row that matches that name in sheet 2?
One of Xlookup (or vlookup for old school but less flexible) or Index/Match I'd say.
I might be missing something though.
Xlookup
Cheers.
@aggi started
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
How do I look up a name in column A of sheet 1 and then return all the values in the row that matches that name in sheet 2?