https://www.canopi.com.au/About-Us/Blog/term/6/locale/en-AU/Blog-Excel Canopi Online Pty Ltd support@canopi.com.au Sat, 02 May 2026 23:33:56 GMT Sat, 02 May 2026 23:33:56 GMT Excel DotNetNuke Blog RSS Generator Version 6.5.4.0 30 https://www.canopi.com.au/About-Us/Blog/Post/320/I-will-never-Use-VLOOKUP-again-Something-better-came-along <p>If you&#39;re like me and had to merge spreadhseets of club members, with training records or any other for of matching records you&#39;ve probably laboured away with VLOOKUP in Microsoft Excel, only to find that its a fickle beast.</p> <p>Well, I&#39;ve found a solution, its a bit harder but way better that VLOOKUP and gives you rock solid matches on multiple columns.</p> <p>Read on, your life will never be the same.</p> greg@canopi.com.au (G McLoughlin-Wilden) G McLoughlin-Wilden Excel Tips https://www.canopi.com.au/About-Us/Blog/Post/320/I-will-never-Use-VLOOKUP-again-Something-better-came-along Wed, 24 May 2017 03:39:00 GMT 2017-05-24 03:39:00Z