Which task is not possible with VLOOKUP?

VLOOKUP searches for a value in the leftmost column of its selected table range, then returns a value from a column to its right. It can use a table on another worksheet and can look up text, numbers, or characters. It cannot return a matching value from a column to the left of the lookup column, so the correct choice is “lookup values located in a column to the left of the column that contains the lookup value.”

AI-written and checked against the verified answer.