Question

50+ POINTS AND BRAIN IF CORRECT 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?
MATCH

INDEX

VLOOKUP

SEEK

Answer 1

Answer:

VLOOKUP

Explanation:

It is the VLOOKUP function that is applied to return the value in a certain row or column in a worksheet, and it can also be used for multiple rows and columns, The formula is =VLOOKUP( VALUE TO LOOK FOR IN THE 1ST COL OF THE TABLE, TABLE( FROM WHICH TO GET THE VALUE, COLUMN INDEX OF THE COLUMN IN THE TABLE  FROM WHICH TO GET THE VALUE, RANGE LOOKUP(EXACT MATCH OR APPROXIMATE MATCH))

Example,

=(H2, A1:D10, 3, true)