6|EXCEL – Join Data Using XLOOKUP for Investors

[Tyler_Loose]

Time to complete: 20 minutes
Difficulty: Beginner

[Hyrum_Draper]

[Tyler_Brickey]

[Katelyn_Hamilton]

Time to complete: 15 minutes
Difficulty: Easy
Solution:

Company Name: =XLOOKUP($A2,Company_Names!$A$2:$A$449,Company_Names!$B$2:$B$449,“Company Name Unavailable”)

Purchase Price:
=XLOOKUP($A2&$C2,‘5_Yr_Stock_Price_Data_2013-2018’!$H$2:$H$619041,‘5_Yr_Stock_Price_Data_2013-2018’!$B$2:$B$619041,1)

Sales Price:
=XLOOKUP(Portfolio!$A2&Portfolio!$G2,‘5_Yr_Stock_Price_Data_2013-2018’!$H$2:$H$619041,‘5_Yr_Stock_Price_Data_2013-2018’!$E$2:$E$619041,1)

[Hazel_Bell]

Fun practice for XLOOKUP!

[Kaisei_Tokuzawa]

Time to complete 25 min

[Austin_Koslow]

Time to complete: 25 min
Difficulty: intermediate

[Nate_Hansen]

Time to complete: 20 Min
Difficulty: Intermediate
Solution:

[Ryan_Muir]

[Charles_T_Garrard]

Time: 30 Minutes
Difficulty: Medium
Solution:

[Lainey_Jackson]

Time to complete: 30 minutes
Difficulty: Intermediate
Solution:

[Ainsley_Barlow]

Time to Complete: 30

[Avalon_Porter]

time: 25 min
Challenge: Beginner-intermediate
Good challenge

https://1drv.ms/x/c/0575b7ce9ece7b23/EZT5tte9uVVOifAYeeXNh84BgKhreALCcS-iN4gc8yCIwg

[Summer_Hanamaikai]

Time to complete: 25 min
Difficulty: Intermediate
Solutions:

[Kerst_Meibos]

Time to Complete: 15 minutes
Difficulty: Easy
It was a good look into what the match type does, going to the next largest number in the range.

Blockquote

[Leah_Robertson]