%3CLINGO-SUB%20id%3D%22lingo-sub-1710371%22%20slang%3D%22en-US%22%3EExcel%20MVP%20Blog%20Roundup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1710371%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20week's%20blog%20roundup%20brought%20to%20you%20by%20Excel%20MVPs%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fmvp.microsoft.com%2Fen-us%2FPublicProfile%2F4025136%3FfullName%3DCharles%2520Williams%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%22%3ECharles%20Williams%3C%2FA%3E%2C%20%3CA%20href%3D%22https%3A%2F%2Fmvp.microsoft.com%2Fen-us%2FPublicProfile%2F5003618%3FfullName%3DDavid%2520Abiola%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%22%3EDavid%20Abiola%3C%2FA%3E%2C%20and%20%3CA%20href%3D%22https%3A%2F%2Fmvp.microsoft.com%2Fen-us%2FPublicProfile%2F5000455%3FfullName%3DYolanda%2520Cuesta%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%22%3EYolanda%20Cuesta%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Ffastexcel.wordpress.com%252F2019%252F05%252F20%252Fcompatibility-of-office-365-dynamic-array-formulas%252F%26amp%3Bdata%3D04%257C01%257CCuong.Pham%2540microsoft.com%257C5d2d498848654f299c3508d8602f57d8%257C72f988bf86f141af91ab2d7cd011db47%257C0%257C0%257C637365103743321432%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%253D%257C1000%26amp%3Bsdata%3D%252BjLJCUmdMyAxHub6ItYex9KeEDjbETl6Xi6nFRg3qRg%253D%26amp%3Breserved%3D0%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%22%3EBackward%20Compatibility%20of%20Dynamic%20Arrays%3C%2FA%3E%3CBR%20%2F%3ECharles%20Williams%20offers%20an%20in-depth%20discussion%20of%20dynamic%20array%20backward%20compatibility%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fwww.exceljetconsult.com.ng%252Fhome%252Fblog%252Flookup-values-in-vba-userform-using-xlookup-function%252F%26amp%3Bdata%3D04%257C01%257CCuong.Pham%2540microsoft.com%257C5d2d498848654f299c3508d8602f57d8%257C72f988bf86f141af91ab2d7cd011db47%257C0%257C0%257C637365103743341425%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%253D%257C1000%26amp%3Bsdata%3DISAvz5M54hYBJQdTxsRKvc3y32m37Z0X8fnA6P1KeEY%253D%26amp%3Breserved%3D0%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%22%3ELookup%20Values%20in%20VBA%20Userform%20using%20XLOOKUP%3C%2FA%3E%3C%2FP%3E%3CP%3EDavid%20Abiola%20provides%20a%20tutorial%20on%20using%20XLOOKUP%20to%20look%20up%20values%20in%20Excel%20VBA%20Userform%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fexcelcontabilidadytic.com%252Fcrea-hoja-excel-gastos%252F%26amp%3Bdata%3D04%257C01%257CCuong.Pham%2540microsoft.com%257C5d2d498848654f299c3508d8602f57d8%257C72f988bf86f141af91ab2d7cd011db47%257C0%257C0%257C637365103743351418%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%253D%257C1000%26amp%3Bsdata%3DDBYJ2htqdSM%252FKCou9YLJxN0%252FGonm%252BIJRl6PzmrPzlR0%253D%26amp%3Breserved%3D0%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%22%3ECrea%20tu%20hoja%20Excel%20de%20gastos%3C%2FA%3E%20(Create%20your%20Excel%20expense%20sheet)%3C%2FP%3E%3CP%3EYolanda%20Cuesta%20shows%20how%20to%20create%20a%20simple%20Excel%20expense%20sheet%20to%20help%20manage%20household%20income%20and%20payments%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFind%20this%20useful%20and%2For%20have%20an%20Excel%20question%3F%20Click%20the%20Like%20button%20and%2For%20leave%20a%20comment%20below%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1710371%22%20slang%3D%22en-US%22%3E%3CP%3E%3C%2FP%3E%3CP%3ECheck%20out%20these%20blog%20articles%20by%20Excel%20MVPs%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fmvp.microsoft.com%2Fen-us%2FPublicProfile%2F4025136%3FfullName%3DCharles%2520Williams%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%22%3ECharles%20Williams%3C%2FA%3E%2C%20%3CA%20href%3D%22https%3A%2F%2Fmvp.microsoft.com%2Fen-us%2FPublicProfile%2F5003618%3FfullName%3DDavid%2520Abiola%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%22%3EDavid%20Abiola%3C%2FA%3E%2C%20and%20%3CA%20href%3D%22https%3A%2F%2Fmvp.microsoft.com%2Fen-us%2FPublicProfile%2F5000455%3FfullName%3DYolanda%2520Cuesta%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%22%3EYolanda%20Cuesta%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1710371%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20MVP%20Blog%20Roundup%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Microsoft

This week's blog roundup brought to you by Excel MVPs Charles Williams, David Abiola, and Yolanda Cuesta

 

Backward Compatibility of Dynamic Arrays
Charles Williams offers an in-depth discussion of dynamic array backward compatibility

 

Lookup Values in VBA Userform using XLOOKUP

David Abiola provides a tutorial on using XLOOKUP to look up values in Excel VBA Userform 

 

Crea tu hoja Excel de gastos (Create your Excel expense sheet)

Yolanda Cuesta shows how to create a simple Excel expense sheet to help manage household income and payments

 

 

 

Find this useful and/or have an Excel question? Click the Like button and/or leave a comment below