What is the purpose of VLOOKUP
Table of Contents
• What does a VLOOKUP do
• How do I use a VLOOKUP?
• What can you do with a VLOOKUP?
What does a VLOOKUP do?
The VLOOKUP function (vertical reference) in Excel is used to determine a value based on a search criterion from a range of cells (the so-called search matrix).
How do I use a VLOOKUP?
The syntax for the VLOOKUP function looks like this:
As Search criterion If a cell address is usually given, you can dynamically change the search criterion by entering a value in this cell.
The Search area (or the search matrix) is a range of cell addresses that can be specified in the form B1: C13. The search criterion is then searched for in the first line of this area.
The Column index indicates which column of the search area is to be read out. All that is expected here is a number.
With the license plate Sorting can specify whether the first column of the search area, i.e. the column in which the search criterion is to be looked up, is sorted or not. For a sorted search area one gives here TRUE an in the case of an unsorted area is the correct entry NOT CORRECT. In principle, the specification of this indicator is optional, so nothing has to be specified. In this case, however, Excel assumes that the search area is sorted. This means that not all values are found in an unsorted search area.
What can you do with a VLOOKUP?
A VLOOKUP can be used to look up values in lists. For example, if you have an article list with article numbers, prices, article descriptions and delivery times, you can use the VLOOKUP function to create a form in another sheet with which you can look up articles by entering the article number in a cell.
2 free trial lessons
- There are active volcanoes on Oahu
- What shoes does a millionaire wear?
- How suspicious are you
- What is Alaska's biggest attraction
- What are the best products to repair bleached hair
- Shops are open on Good Friday
- Can acupuncture treat psoriasis effectively
- What is twilight anesthesia
- How do babies get their teeth brushed
- Why didn't Hitler use his nerve agents?
- What is 90 45 90
- Democracy means holding elections on a regular basis
- Curses better expresses your point of view
- Why do I repeat harmful behavior?
- Would you kill in self defense
- What does lavender symbolize the flower
- Which flower is written with 3 letters
- How has the beauty operation developed over time
- Is gravity a force or not
- On which page is the attachment
- Uses Twitter in an agile manner
- How fast can a pig run
- Or is org really necessary to the success of a website
- Is the converter a static device