Learn
Courses
Career Tracks
Projects
Certificates
Career Track Certificate
Course Certificate
Resources
All Resources
Templates
Course Notes
Career Guides
Cheat Sheets
Finance Data
Infographics
Practice Exams
Knowledge Hub
Career Advice
Reviews
Pricing
For Business
Login
Sign Up
Log In
Sign Up
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?
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
Al3x
0
2
Formating text to columns gives dates instead of numbers