Computer Power Point
nmdcat.online May 22, 2026

What is the function of Vlookup formula in Excel ?

A. VLOOKUP retrieve data base on specified criteria from the most left column of the table, searching vertically down for a specified value.
B. VLOOKUP stands for “Value Lookup,” which searches horizontally across the top row of a table for a specified value.
C. VLOOKUP returns a value from the same row as the lookup value, but from a column specified by the user.
D. VLOOKUP scans the entire table and returns the first value found that matches the lookup criteria.

📖 Additional Information

  • VLOOKUP retrieve data base on specified criteria from the most left column of the table, searching vertically down for a specified value.
  • VLOOKUP stands for “Value Lookup,” which searches horizontally across the top row of a table for a specified value.
  • VLOOKUP returns a value from the same row as the lookup value, but from a column specified by the user.
  • VLOOKUP scans the entire table and returns the first value found that matches the lookup criteria.

🔗 Share This Question