Using vlookup function in excel

The function of Vlookup is to read and select the data in the table vertically in line. Vlookup will be more useful when you have in large numbers of data and the data location in different places.

Here is how to make it.

1) Create a table of sources data such as below or you can use existing data.

Picture 01. Source data

2) Create a table of destination data. Then type the function = VLOOKUP in cell B23.

Picture 02. Destination data

Range so that data does not change, make 'Source Data'! A23:B28 becomes absolute by pressing F4 [enter]. Select A23:B28 and then press F4 [enter].

Before:

=VLOOKUP(A23,'Source data'!A23:B28,2,FALSE)

After: [Absolute]

=VLOOKUP(A23,'Source data'!$A$23:$B$28,2,FALSE)

Note:

1. Lookup value

2. Table array (source data)

3. Column index number (target data/ data to be shown)

4. Range lookup (false or true)

3) Test by inserting one of the data from the data source. If successful, drag the function.

Picture 03. Test function

#N/A Appear if the data ID has not been inserted.

Here's the end result

Picture 04. Vlookup

Additional data validation

By adding data validation, we do not need to type the data one by one. Data validation will limit the data area according to the data table range.

1) Click DATA and select the Data Validation excel