Lookup Value error only some matching despite same...

Any idea why this would happen? All cells are the same, yet lookup value isn't working for all of them?

1 REPLY 1

Usually caused by spaces or hidden characters. Try cleaning, trimming the column

Helpful resources

Announcements

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.