Courses
Learning Paths
Learning Paths
Career Paths
Career Paths
See all
Career Paths
See all
Data analyst
Data scientist
Business analyst
Senior data analyst
Senior data scientist
Tableau developer
Power BI developer
Data engineer
Machine learning scientist
AI engineer
Bootcamp
We are accredited by
Resources
Resources
Projects
Career Kit
Career Kit
Career Kit
Interview Simulator
Career Quiz
Career Guides
Study Kit
Study Kit
Study Kit
Flashcards
Course Notes
Practice Exams
Infographics
Coding Templates
Blog
Student Outcomes
Student Outcomes
Reviews
Student Stories
Student Outcomes Report
Pricing
For Business
Log in
Start free
Follow this topic
Share
Tansaya Khajikhan
Last answered:
31 Jan 2024
Posted on:
30 Nov 2022
2
use xlookup instead
in
Introduction to Excel
/
Using Lookup Functions (Vlookup) to Fill the Database Sheet
use xlookup instead of vlookup.
1 answers ( 0 marked as helpful)
Juan Wagner
Posted on:
31 Jan 2024
0
Why is that?
Submit an answer
Submit answer
related questions
Mario Contreras
1
12
Why are we using SUMIF to transfer data instead of using VLOOKUP?
P Sudeep
3
10
Use Sumif to complete the dataset.
Yasser Attia
0
8
Resolved:
please advise is there any pdf or written materials for every lecture? as i can use for revising the
Syed Muhammad Mudassir
1
4
when to use waterfall chart??
Dylan Ritter
0
4
Resolved:
Column width increasing instead of decreasing?
Sven Kielmann
0
4
Resolved:
Would it not be easier to simply concatenate with ", " instead of ","&" "
Jamil Siddique
1
2
request for open use
Brenda Nadam-Olegnowicz
0
2
Resolved:
Can I use Google Sheets instead of Excel?
Dylan Ritter
0
2
Resolved:
Why use Index Match when you can just use Index?
James Trinh
0
2
Resolved:
I can't use the Rank Function with my current version of Excel, they told it just for old versions
Asim Shamshad
1
2
why direct costs are not in cost section instead of adding up in gross margins?
Zulkifli Nurhakim Halida
0
2
Resolved:
add $ by using F4 instead