={INDEX(Data,MATCH(ROW(INDIRECT("1:"&ROWS(Data)))-1,COUNTIF(Data,"<" &Data),0))}Sorts the data from last to firstSorts the data alphabeticallyHighlights a number if it is less than DataGives the position of the least element in Data minus one

={INDEX(Data,MATCH(ROW(INDIRECT("1:"&ROWS(Data)))-1,COUNTIF(Data,"<" &Data),0))}Sorts the data from last to firstSorts the data alphabeticallyHighlights a number if it is less than DataGives the position of the least element in Data minus one

={LARGE(Data,ROW(INDIRECT("1:"&ROWS(Data))))}The above:sorts Datacounts the largest N values of Datareverses the order of Datasums the largest N values of data

For specified Unit # in cell B2 on image provided, what should be an correct for INDEX - MATCH lookup function that provide Rental Price in cell E2?Assume that the data range start from row 7 to row 56. Group of answer choices=INDEX(A7:H56,MATCH(B2,A7:A56,0),4)=MATCH(A7:H56,INDEX(B2,A7:A56,0),4)=INDEX(A7:H56,MATCH(B2,A7:H56,0),1)=INDEX(A7:H56,MATCH(B2,A7:H56,1),1)

Which function displays row data in a column or column data in a row?Answer areaReverseNone of the aboveIndexTranspose

Looking Up Data - INDEX() & MATCH()How do the INDEX() and MATCH() functions work together to fetch data?The MATCH() function uses the INDEX() function to ascertain the relative position of data in the lookup arrayMATCH() identifies equivalent values in the lookup and source tables, while INDEX() provides the position of those valuesINDEX() identifies the relative position in the source array and produces values for MATCH() to referenceThe MATCH() function, when placed inside the INDEX() function, gives the relative position of data within the lookup array