Excel – VLookup – Unique Join WorkSheets

Posted on By David Kittell 
=VLOOKUP(B2,Sheet2!A:B,2,FALSE)

Sheet1

Column A Column B
Moo ./.htaccess

Sheet2

Column A Column B
./.htaccess 235

Add the code above to Column C in Sheet1 and it will match Column B from Sheet1 with Column A from Sheet2 and get the value to display from Column B from Sheet2

Originally Posted on February 10, 2016
Last Updated on February 12, 2016
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Code Excel Microsoft Office

Related Posts

PowerShell – RSS Feed Reader

Posted on

clear $rssFeedURL = ‘http://www.kittell.net/feed/’ $rssFeed = 1(New-Object System.Net.WebClient).DownloadString($rssFeedURL) $rssFeed.rss.channel.item | Select-Object title, link -First 5 | Format-Table -AutoSize GitHub: https://gist.github.com/dkittell/ca4025e4e78ccecbb5f0 Originally Posted on December 15, 2015Last Updated on February 12, 2016 All information on this site is shared with the intention to help. Before any source code or program is…

Read More

Android Contacts – Set Text Case

Posted on

UPDATE data SET data1 = lower(data1) WHERE mimetype_id IN ( SELECT _id FROM mimetypes WHERE mimetype LIKE "%email%" ); Originally Posted on March 2, 2014Last Updated on October 26, 2015 All information on this site is shared with the intention to help. Before any source code or program is ran…

Read More