Question

Three different areas of life of VLOOKUP

Answer 1

I have identified the practical uses of VLOOKUP functions in the following three areas:

Education: A teacher with a list of student scores can use VLOOKUP to translate them to grades.

Sales: Sales managers can use VLOOKUP to determine the commissions their salespeople have earned.

Shopping: You can browse online catalogs for product listings and find their corresponding prices using VLOOKUP.

Step-by-step explanation:

Answer 2

Answer and Explanation:

The three different areas fo VLOOKup is as follows

1. The Primary key which is used for matching up your data for example, employee id, employee address etc

2. The list of lookup that represents the database i.e employees list who are working in an organization

3. the data which is required to match it or shifting the data