, which can be supplied as A variety of cells or an array consistent. The syntax for that array form of INDEX is: This technique illustrates one good thing about the 2-action approach utilized by INDEX and MATCH: Mainly because INDEX expects a numeric index for row and column figures, https://www.kaldirimcanavari.tumblr.com/