Рет қаралды 3,801
I wrote an article about how to use functions such as VLOOKUP and MATCH and how to use Name Definition as a way to find a value that satisfies both a row and a column from a data table entered in an Excel worksheet.
※ [Excel] Finding data that satisfies both rows and columns at the same time, January 18, 2009, cantips.com/1015
※ [Excel] Finding data that satisfies both rows and columns 2, January 6, 2011, cantips.com/1759
This article was posted 10 years ago, but it is still valid.
In fact, you can apply a slightly different method, such as using the INDEX function, but here we will learn how to use "name" and how to use XLOOKUP, one of the relatively new functions introduced.
Functions used:
- XLOOKUP
- INDIRECT
- IFERROR
#Excel