tag:blogger.com,1999:blog-26981669.post4366411551595501238..comments2024-03-23T10:55:30.196-05:00Comments on Cold Fusion Guy: Excel VLOOKUP exampleJim Peethttp://www.blogger.com/profile/07649414726939918803noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-26981669.post-28092891322519539922013-12-10T21:17:01.802-06:002013-12-10T21:17:01.802-06:00Then there is INDEX MATCH. Supposed to be faster t...Then there is <a href="http://www.businessinsider.com/excel-index-match-2013-7" rel="nofollow">INDEX MATCH</a>. Supposed to be faster than LOOKUP and no need to sort the table. I tried it tonight ... works fine but the syntax is complex ... I mean COMPLEX!Jim Peethttps://www.blogger.com/profile/07649414726939918803noreply@blogger.comtag:blogger.com,1999:blog-26981669.post-27923756680471209072013-12-10T09:47:45.024-06:002013-12-10T09:47:45.024-06:00I worked on this again last night. I think the LOO...I worked on this again last night. I think the LOOKUP function has easier syntax. I replaced all VLOOKUP functions with LOOKUP.Jim Peethttps://www.blogger.com/profile/07649414726939918803noreply@blogger.comtag:blogger.com,1999:blog-26981669.post-82718607469901663952013-12-07T17:31:28.931-06:002013-12-07T17:31:28.931-06:00The LOOKUP function may be easier. linkThe LOOKUP function may be easier. <a href="http://support.microsoft.com/kb/324986/PL" rel="nofollow">link</a>Jim Peethttps://www.blogger.com/profile/07649414726939918803noreply@blogger.comtag:blogger.com,1999:blog-26981669.post-50666663398008858972013-12-07T11:33:42.316-06:002013-12-07T11:33:42.316-06:00Easier with Microsoft Access (which I have on my w...Easier with Microsoft Access (which I have on my work PC) ... but I only have Excel to work with on my home MacBookJim Peethttps://www.blogger.com/profile/07649414726939918803noreply@blogger.com