What Is The Lookup Function In Excel & How Do You Use It?
while the array form works with larger table-like data ranges. There are also advanced Excel functions like VLOOKUP, HLOOKUP, ...