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
AI agent 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
Sven Kielmann
1
4
Resolved:
Would it not be easier to simply concatenate with ", " instead of ","&" "
Dylan Ritter
0
4
Resolved:
Column width increasing instead of decreasing?
Syed Muhammad Mudassir
1
4
when to use waterfall chart??
Obiora Nwankwo
0
2
Data table amount to be paid: can we use the PMT function ?
Brenda Nadam-Olegnowicz
0
2
Resolved:
Can I use Google Sheets instead of Excel?
Lucia Indah Pramanti
0
2
Resolved:
Formula for y.o.y variations. Why IF instead of IFS?
Al3x
0
2
Formating text to columns gives dates instead of numbers
Ahmed Khalifa
0
2
Watch full sections instead of micro lessons
Dylan Ritter
0
2
Resolved:
Why use Index Match when you can just use Index?