Loading...

London

VLOOKUP in Excel (Simplified from beginner to advanced) | EXCEL VLOOKUP | VLOOKUP FORMULA

1,820 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Feb 28, 2019

FREE Webinar: £27K to £100K Salary In 3 years With These Excel Skills
Sign up here: https://earnandexcel.com/excel-traini...

Once, you’ve seen the Excel VLOOOKUP Formula video, the head over to download the free article: https://earnandexcel.com/excel-vlookup/


The VLOOKUP is the quickest, most convenient and simplest Excel formula for finding information from a list. So, providing you store your data vertically in a list, the VLOOKUP will allow you to identify a particular item then discover associated information about it.

The VLOOKUP function is able to use a given reference and look for it in a specified range and then return a value from the same row in another column. You can instruct the function to find an exact match or the closest match. The former is best used for ID’s when you need to find a person’s employee number or a product ID for example, the latter is useful for finding a graded result if the lookup criteria sits in between a bracketed range.

The function broken down looks like the below, in summary we will ask:

=VLOOKUP(Your reference, The range where your reference and result appears, which column number in the range is the result found in, do you want the reference to match exactly or a close match?)

In simple terms:

Find my reference in a range, when you find it, please tell me the piece of information that is x amount of columns to the right of that data

Let’s take a look at the structure of the VLOOKUP as found in Excel.

=VLOOKUP(lookup_value, table_array, col_index_number, [range index number])

Breaking down each element, Excel defines these as:

lookup_value

Is the value to be found in the first column of the table, and can be a value, a reference, or a text string. This is your employee or product ID I mentioned above

table_array

Is at table of text, numbers, or logical values, in which data is retrieved. Table_array can be a reference to a range or a range name.

col_index_number

Is the column number in a table_array from which the matching value should be returned. The first column values in the table in column 1.

[range index number]

Is a logical value: to find the closet match in the first column (sorted in ascending order) = TRUE or omitted; find an exact match = FALSE. Additional note, you can also use a zero 0 (for FALSE) or a one 1 (for TRUE).

Now, I hope you found that tremendously helpful!
Thanks for watching the video and don’t forget to download the Free VLOOKUP book:
https://earnandexcel.com/excel-vlookup/
Sohail

#VLOOKUP #Excel

Loading...

Advertisement

to add this to Watch Later

Add to

Loading playlists...