Загрузка...

How to use Vlookup & Hlookup in Excel || Step by Step | Detail | Tutorial | IN HINDI

How to use Vlookup & Hlookup in Excel || Step by Step | Detail | Tutorial | IN HINDI
Please Like & Subscribe channel
https://www.youtube.com/@fjkitechpathshala7269
00:00 Introduction of Lookup
01:55 Applying Vlookup formula from method -1
05:27 Applying Vlookup formula from method -2
08:00 Lock cell by using Dollar ($)
10:00 Applying Vlookup formula using Different Sheet in Same Workbook
12:30 Applying Vlookup formula using approx match
14:45 Applying Hlookup formula using Horizontal Data

How to use Vlookup & Hlookup in Excel || Step by Step | Detail | Tutorial | IN HINDI

In its simplest form, the VLOOKUP function says:

=VLOOKUP(What you want to look up, where you want to look for it, the column number in the range containing the value to return, return an Approximate or Exact match – indicated as 1/TRUE, or 0/FALSE).
How to get started
There are four pieces of information that you will need in order to build the VLOOKUP syntax:

The value you want to look up, also called the lookup value.

The range where the lookup value is located. Remember that the lookup value should always be in the first column in the range for VLOOKUP to work correctly. For example, if your lookup value is in cell C2 then your range should start with C.

The column number in the range that contains the return value. For example, if you specify B2:D11 as the range, you should count B as the first column, C as the second, and so on.

Optionally, you can specify TRUE if you want an approximate match or FALSE if you want an exact match of the return value. If you don't specify anything, the default value will always be TRUE or approximate match.

Now put all of the above together as follows:

=VLOOKUP(lookup value, range containing the lookup value, the column number in the range containing the return value, Approximate match (TRUE) or Exact match (FALSE)).

How to use Vlookup & Hlookup in Excel || Step by Step | Detail | Tutorial | IN HINDI

VLOOKUP Function
The VLOOKUP function is a premade function in Excel, which allows searches across columns.

It is typed =VLOOKUP and has the following parts:

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

Note: The column which holds the data used to lookup must always be to the left.

Note: The different parts of the function are separated by a symbol, like comma , or semicolon ;

The symbol depends on your Language Settings.

Lookup_value: Select the cell where search values will be entered.

Table_array: The table range, including all cells in the table.

Col_index_num: The data which is being looked up. The input is the number of the column, counted from the left:
Range_lookup: TRUE if numbers (1) or FALSE if text (0).

Note: Both 1 / 0 and True / False can be used in Range_lookup.

How to use the VLOOKUP function.
Select a cell (H4)
Type =VLOOKUP
Double click the VLOOKUP command
Select the cell where search value will be entered (H3)
Type (,)
Mark table range (A2:E21)
Type (,)
Type the number of the column, counted from the left (2)
Type True (1) or False (0) (1)
Hit enter
Enter a value in the cell selected for the Lookup_value H3(7)
Let's have a look at an example!

Use the VLOOKUP function to find the Pokemon names based on their ID
H4 is where the search result is displayed. In this case, the Pokemons names based on their ID#.

#playlists
https://www.youtube.com/@fjkitechpathshala7269/playlists

#excel
https://www.youtube.com/watch?v=efh5YApCP-g&list=PLx0QJ6kp8ZMQho2SA-QQKU6E_TiJBd5Jp

#coreldraw
https://www.youtube.com/watch?v=jg0mVx-_JWs&list=PLx0QJ6kp8ZMRWg2fmgzKQ5ogzWeSy1zp8

Thanks for Watching
Please Like ,comment ,Subscribe & Share

Видео How to use Vlookup & Hlookup in Excel || Step by Step | Detail | Tutorial | IN HINDI канала FJ KI TECH PATHSHALA
Страницу в закладки Мои закладки
Все заметки Новая заметка Страницу в заметки

На информационно-развлекательном портале SALDA.WS применяются cookie-файлы. Нажимая кнопку Принять, вы подтверждаете свое согласие на их использование.

Об использовании CookiesПринять