In this article, we will cover how to look for relevant data in other sheets in excel using Vlookup and Xlookup
What is VLOOKUP Function in Excel
Vlookup work is utilized to query the value with a reference cell and get the value from the selected table and is very valuable and quite possibly the most utilized excel function.
We can use a table or single column to look up the value. And all the lookup can be done in a vertical zone or with columns only.
What is XLOOKUP function in Excel
The Excel XLOOKUP function is a modern and flexible replacement for older functions like VLOOKUP, HLOOKUP, and LOOKUP. XLOOKUP supports approximate and exact matching, wildcards (* ?) for partial matches, and lookups in vertical or horizontal ranges.
Difference between VLOOKUP AND XLOOKUP
VLOOKUP
This function scans down the row headings at the side of a table to find a specified item. When the item is found, it then scans across to pick a cell entry.
Syntax
=VLOOKUP(ItemToFind, RangeToLookIn,ColumnToPickFrom,SortedOrUnsorted)The ItemToFind is a single item specified by the user.
The RangeToLookIn is the range of data with the row headings at the left-hand side.
The ColumnToPickFrom is how far across the table the function should look to pick from.The SortedOrUnsortedis whether the table obtained is sorted or not sorted
XLOOKUP
XLOOKUP is the newest member of Excel lookup function family.
Using XLOOKUP function we can find things in a table or range by row. ... With XLOOKUP, we can look in one column for a search term and return a result from the same row in another column, regardless of which side the return column is on.
Syntax
=XLOOKUP (lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) - lookup value is
the value to search for - lookup array is
the array or range to search - return array is
the array or range to return - [if_not_found]
Where a valid match is not found, return the [if_not_found] text you supply. - [match_mode]
Specify the match type - [search_mode]
Specify the search mode to use
XLOOKUP gives you the lookup to the left, performs binary search and many other operations where the VLOOKUP is lagging. Once data is obtained we can also create a chart to compare it.
Conculsion
This article covered finding relevant data in a spreadsheet using Excel functions called VLOOKUP and XLOOPUP, we also provided an insight into the difference between the two functions. We hope it is useful.
