Researchv (which you can also find under his English name Vlookup) travels a column vertically from top to bottom to find the values you are looking for. Even in extremely large directories, you can quickly find relevant information thanks to the sensitive reference function. In our article, you will discover how to use this formula using concrete example.
Researchv: What is this formula for Google Sheets for?
Sanding offers users many advantages to work effectively and quickly with calculation sheets and tables. However, professional users know A series of practical formulas which simplifies and automatize work with Excel or Google Sheets. Researchv is for example a formula that allows you to find in no time information and values in huge repertoires and voluminous tables. But how is the research function are exactly used?
Advice
This function also exists in Microsoft's famous spreadsheet. The search formula in Excel works similarly to the Google variant.
Let us start from the principle that you have a very Large repertoire with customer names, client numbers and addresses. Each customer sheet is accompanied by a column in which the product category is registered in which the customer most often orders items from your online store. A telephone call is planned with a person registered in the directory and you want to know quickly which category of products is allocated to him. Using the customer number and the search formula in Google Sheets, you can find the corresponding value of the search criterion without having to manually browse the whole list to find the information sought. What is more, Google Sheets' formula is working in other spreadsheets, allowing you to cross -checking disseminated information in several different places.
Google Workspace (formerly G Suite)
Facilitate teamwork
- All Google tools in the same place
- Professional messaging via Gmail
- Domain name included in the 1st year
Researchv syntax in Google Sheets
As with any other formula, you must enter Research to properly within the cell If the formula is not correct, Google Sheets cannot correctly carry out the automatic determination of the value. Google Sheets' research formula requires several conditions and is used as follows:
=RECHERCHEV(Clé_recherche;plage;index;[est_trié])There » search key Is the value you are looking for. In the » beach « , You define the part of the table in which the value must be sought. By » index », We designate the place of the table which contains the return value of your research. The index is indicated as a simple number in the formula. If your search key is found in column C and you are looking for a corresponding value in column F, the index must be indicated by 3, because column F is far from three columns of the C.
Note
With Google's spreadsheet, you can use the English function « Vlookup » or its French equivalent « Researchv »: depending on the linguistic parameter of your Google account, the software will automatically translate the name of the function.
The switch » [est_trié] « Indicates whether the column in which the research will be carried out, is a column already sorted or not. If the column is not sorted, we write « false », and if it is already sorted, we register the « true » option. If we do not specify anything, Google Sheets starts from the principle that it is « true ». Although this parameter is optional, it has great importance for the result.
- FAKE : The function is looking for an exact concordance and brings you the first occurrence found.
- FAKE : The function does not necessarily seek an exact concordance, but gives you the occurrence closest to the search key. Take the example of this research in Google Sheets:
=RECHERCHEV(A10;A2:E10;3;FAUX)This formula asks Google Sheets to carry out vertical search in the column located at three columns of the A. The search is carried out in the A2 to C10 tables. The search criterion is entered in the A10 column. Google Sheets must display the corresponding value of the C. C.
Advice
Are you looking for a modern office solution for your business? Google Ionos Workspace offers you many advantages, for example personalized messaging areas and 30 GB of online storage for each member of the team. In addition, you benefit at Ionos with additional Google assistance.
Researchv (vlookup) in Google Sheets: example
The example of a concrete research is more telling. To do this, we use the following table as a starting base:
Step 1 : Insert, in a location of your choice, below or next to the table, a workspace in which you will do your research. Just enter « key » and « result » in the header. In the first line, below « key », type the cell value, for which you want to look for the corresponding result.
Step 2 : Enter the Searchv function in Google Sheets where you want to see the result of your search. In our example, this is cell B14. Enter the following formula:
=RECHERCHEV(A14;$A$2:$E$10;5;FAUX)
Step 3 : The « cosmetics » result is now displayed in the column where you have seized the search form.
Step 4 : You can now indicate any customer number of the column has as a search key. Adapt the formula to the corresponding location or click in the « cosmetics » result field and slide the small blue point downwards, in the cell below. The formula thus adapts automatically and gives you the desired result.
