Hi - Dave here.
How can you lookup an entire column with a formula?
The XLOOKUP function makes it really easy. For example, in the worksheet below, H3 contains the lookup value "Q3", and the formula in H4 is:
=XLOOKUP(H4,quarter,data)
The result is that XLOOKUP finds and retrieves all data for Q3:
[
download the workbook and read the full explanation]
This problem can also be solved with INDEX and MATCH. See the article and attached workbook for details.
Excel formulas
We maintain a large list of working formulas
here.
If you need more structure, we also offer
video training.
Have a fun and safe weekend!
Dave
