6|EXCEL – Join Data Using XLOOKUP for Investors

[Keldon_LaRose]

Good work!

[Travis_Fehlberg]

This one was really cool! I had no idea that XLOOKUP had so many other parameters and it was a good way to learn one more. I was super stumped and was wondering why my dollar values weren’t showing correctly after I had done all the formulas, and as able to find out how to use the match parameter. So cool! Here is my solution posted below.

[Liza_Hladek]

Thanks for the challenge! Here is a screenshot of my solution.

[Nathanael_Awerkamp]

Challenge6_5_Yr_Stock_Price_Data_2013-2018.xlsx (20.8 KB)

[Collin_Beus]

Great challenge! This helped me understand XLOOKUP a lot better.

Summary

This text will be hidden

[Christian_Stover]

I learned a lot about XLOOKUP. I knew it a few classes ago but it got pushed out of my memory. Now I feel more confident in my ability to use this formula.

[Jenna_Sofoul]

It would not let me upload the excel file… it said it was too big of a file.
Here is my screenshot! Great challenge!

[Zachary_Decker]

Xlookup might be my favorite function in any data software ever. It is so useful and saves so much time and is easier to use than a vlookup or h lookup.
The unique identifiers were a little finicky for me, but I was able to get them to work!

[OliviaLundgreen]

Great challenge! It’s been a whiile since I used XLOOKUPS. This was a great refresher.

[Benjamin_Lau]

Here is my version of the answer. Great Practice of xlookup and I just remember there is a fuzzy match option under that function. Super cool stuff, never forget again!

[Nicholas_Goodwin]

This challenge was great! The data was very good and easy to understand. I enjoyed getting a refresher on xlookups.I’ve attached a screenshot with the first few rows of my data.

[Anthony_Ferrante]

Great challenge!

[Haley_Duggan]

This was a nice challenge! It really tested my XLOOKUP() skills. Here are my results!

[Jackson_Carter]

Time to Complete: 5 minutes
Difficulty: Beginner
It was good practice for the XLOOKUP function!

[Joshua_Anderson]

I had fun practicing XLookup in this challenge! I wasn’t aware of the match mode part of XLookup so that’s something that I’m sure will be useful in the future.
Name Column: =XLOOKUP(A2,Company_Names!$A$2:$A$449,Company_Names!$B$2:$B$449, “Company Name Unavaliable”)
Purchase Price:
=XLOOKUP(Portfolio!C2&Portfolio!A2,‘5_Yr_Stock_Price_Data_2013-2018’!$H$2:$H$619041,‘5_Yr_Stock_Price_Data_2013-2018’!$B$2:$B$619041,1)
Sale Price:
=XLOOKUP(G2&A2,‘5_Yr_Stock_Price_Data_2013-2018’!$H$2:$H$619041,‘5_Yr_Stock_Price_Data_2013-2018’!$E$2:$E$619041,1)

[Gavin_Ross]

Time to complete: 15 minutes
Rating: Beginner
I enjoyed learning trying out the [if_not_found] part of the lookup function!

[Ashleigh_Layton]

Time to complete: 30 minutes
Difficulty: Beginner
Comments: Great practice with XLOOKUP. I feel a lot more confident with how it works.
Solution:

[Anela_Zamarron]

I enjoyed practicing my xlookups. This was a solid challenge. I will say the portfolio tab took me a little to figure out how to interpret but I eventually figured it out. Thanks for putting this together

[Layton_Allred]

Time to complete: 20 minutes
Rating: Beginner
Solution:

[Aaron_Greenwood]

Time to complete: 20 mins
Difficulty: Medium