vlookup.com
Open in
urlscan Pro
76.76.21.21
Public Scan
Submitted URL: http://xlookup.com/
Effective URL: https://vlookup.com/excel/xlookup
Submission: On December 29 via api from BY — Scanned from FR
Effective URL: https://vlookup.com/excel/xlookup
Submission: On December 29 via api from BY — Scanned from FR
Form analysis 1 forms found in the DOM
<form><input type="text" value="103"></form>Text Content
Use of Cookies
This site uses cookies to improve your browsing experience, perform analytics
and research, and conduct advertising. To change your preferences, click
Settings. Otherwise, clicking Accept indicates you agree to our use of cookies
on your device. Cookie Policy
Settings Reject All Accept All
Our site uses cookies.
Some of these cookies are essential, while others help us to improve your
experience by providing insights into how the site is being used.
When you visit any website or application, it may store or retrieve information
on your browser, mostly in the form of cookies. This information might be about
you, your preferences or your device and is mostly used to make the site work as
you expect it to. The information does not usually directly identify you, but it
can give you a more personalised web experience. Because we respect your right
to privacy, you can choose not to allow some types of cookies. Review the
different categories to find out more and change our default settings. However,
blocking some types of cookies may impact your experience of the site and the
services we are able to offer.
NecessaryAlways Active
Necessary cookies are required to enable the basic features of this site, such
as providing secure log-in or adjusting your consent preferences. These cookies
do not store any personally identifiable data.
No cookies to display.
Analytics
Analytical cookies are used to understand how visitors interact with the
website. These cookies help provide information on metrics such as the number of
visitors, bounce rate, traffic source, etc.
* Cookie
_ga
* Duration
2 years
* Description
The _ga cookie, installed by Google Analytics, calculates visitor, session
and campaign data and also keeps track of site usage for the site's analytics
report. The cookie stores information anonymously and assigns a randomly
generated number to recognize unique visitors.
* Cookie
_ga_L7C4G0YZRC
* Duration
2 years
* Description
This cookie is installed by Google Analytics.
Reject All Save My Preferences Accept All
Powered by
<iframe src="https://www.googletagmanager.com/ns.html?id=GTM-MW7HK8R" height="0"
width="0" style="display:none;visibility:hidden"></iframe>
All examplesTroubleshooting
Microsoft Excel
Google Sheets
HOW TO USE XLOOKUP IN EXCEL
In Excel, XLOOKUP is a modern and flexible alternative for VLOOKUP, to find a
value from a table or a list and then return a related result.
In this example, we'll retrieve an employee's email based on their ID:
Formula in G3
Copy formula
=XLOOKUP(G2;B3:B6;D3:D6)
Result
The value that is returned from the formula.
Lookup value
The value to look for in the Search range.
Search range
A range that must contain the Lookup value.
Result range
The range that contains the expected Result.
A
B
C
D
E
F
G
H
1
👇 Try changing this value
2
ID
Name
Email
Lookup value
3
101
James
james@example.com
Result
elizabeth@example.com
4
102
Mary
mary@example.com
5
103
Elizabeth
elizabeth@example.com
6
104
Ashley
ashley@example.com
7
Download as .xlsx
Show arrows
Separator
PROCEDURE
1. Enter =XLOOKUP in cell G3, where you want the Email address to appear.
2. Enter the Lookup value G2, containing the ID (103) you want to look for.
3. Enter the Search range B3:B6, the range of data that contains all the ID
values.
4. Enter the Result range D3:D6, containing the Email values your want to
return.
RESULT
The final formula is: =XLOOKUP(G2, B3:B6, D3:D6)
XLOOKUP returns the value in D5, which is elizabeth@example.com.
Show reference
← PreviousVLOOKUP partial matchNext →VLOOKUP with multiple criteria
Made by
Discover our products:
YAMMAwesome TableForm PublisherGPT for Work
VLOOKUP examplesTroubleshooting
Give us your feedbackSign up for updatesPrivacy policyCookie policyImpressum