while the array form works with larger table-like data ranges. There are also advanced Excel functions like VLOOKUP, HLOOKUP, and XLOOKUP that provide more advanced lookup functions that offer ...