Excel Vlookup and XVlookup Example and how to use

MS Excel: How to use the VLOOKUP Function (WS)

This Excel tutorial explains how to use the VLOOKUP function with syntax and examples.

Description

The VLOOKUP function performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position.

The VLOOKUP function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the VLOOKUP function can be entered as part of a formula in a cell of a worksheet.

Vlookup is allow user to extract one workbook to anther workbook.

New update 

=XLOOKUP(lookup_value,lookup_array,return_array,if_not_found,match_mode,search_mode)

lookup_value: The VLOOKUP function performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position.

lookup_array: It can be used as a worksheet function (WS) in Excel. As a worksheet function, the VLOOKUP function can be entered as part of a formula in a cell of a worksheet.

return_array: the Table value wanted to show the results

if_not_found: When result is not appears

match_mode: True/False (Exact Value/Approx value)