Formula: =VLOOKUP(E1,CHOOSE({1,2},B1:B7,A1:A7),2,FALSE) Explain: CHOOSE({1,2},B1:B7,A1:A7): as table_range argument in the VLOOKUP function. {1,2} means to display 1 or 2 as index_num argument based on the col_num argument in VLOOKUP function. Here, the col_num in VLOOKU...
To return the array in range A1:C5 of rows 1 and 3, please select a cell and use the formula as this: =CHOOSEROWS(A1:C5,1,3) PressEnterkey. If you want to quickly get the last two rows of the array, you can use the formula as this: ...