By matching Array of Coulums,Array of Row the result should be name of particular
By matching Array of Coulums,Array of Row the result should be name of particular
xlookup hahaha
Dear All,
we can use index + match formula for this problem as following
INDEX(B3:B8,MATCH(D3,D3:D8,0))