EXCEL CHALLENGE: Crack the Code! Decode Resistor Colors with an EPIC Formula! (Advanced Functions)

Today's challenge puts your advanced formula skills to the test. Can you crack the resistor color code and decode resistance values with a single, powerful formula?

MAP & LAMBDA: Harness the power of these advanced functions for a concise and elegant solution.
LET: Enhance code readability by assigning temporary values.
XMATCH: Utilize the newest addition to the Excel family for efficient color code lookup.
MID, SEQUENCE, & LEN: Masterfully manipulate text strings to extract color codes.
DROP & TAKE: Isolate specific characters within the color code.
CONCAT & REPT: Combine elements to build the final formula.
Get ready to push your Excel boundaries and unlock a secret weapon for electronics enthusiasts! Ready to accept the challenge?

P.S. Don't forget to share your completed formula and any creative approaches in the comments below!

‭Philippians 4:7 NIV‬
"And the peace of God, which transcends all understanding, will guard your hearts and your minds in Christ Jesus."

P.S. Don't forget to leave a comment below with your solution and chosen divisor number!