Question

formula of vlook up class 10 computer ​

Answer 1

Answer:

• In the Formula Bar, type =VLOOKUP().
• In the parentheses, enter your lookup value, followed by a comma. ...
• Enter your table array or lookup table, the range of data you want to search, and a comma: (H2,B3:F25,
• Enter column index number.

Answer 2

Answer:

What is VLOOKUP in Excel?

The VLOOKUP function in Excel is a tool for looking up a piece of information in a table or data set and extracting some corresponding data/information. In simple terms, the VLOOKUP function says the following to Excel: “Look for this piece of information (e.g., bananas), in this data set (a table), and tell me some corresponding information about it (e.g., the price of bananas)”.