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!