Which function is used to return the value in a particular row and/or column in a worksheet and can also be used with multiple rows and columns?

INDEX returns the value at a specified position in a range, using a row number and, when needed, a column number. It can work with ranges containing multiple rows and columns; MATCH finds a position, while VLOOKUP searches by column.

AI-written and checked against the verified answer.