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

Java – FRC – Limelight Vision – Basic Information Read

Posted on

The code below will help you to be able read basic information from your Limelight Vision camera. If you haven’t already read the documentation it’s a good idea to start there -> http://docs.limelightvision.io/en/latest/ Start with a new “Timed Robot” template project and add a few imports import edu.wpi.first.networktables.NetworkTable; import edu.wpi.first.networktables.NetworkTableEntry;…

Read More

PowerShell – IPv4 Range

Posted on

This first function is helpful to provide a range of IPv4 addresses within a set range function New-IPRange ($start, $end) { # created by Dr. Tobias Weltner, MVP PowerShell $ip1 = ([System.Net.IPAddress]$start).GetAddressBytes() [Array]::Reverse($ip1) $ip1 = ([System.Net.IPAddress]($ip1 -join ‘.’)).Address $ip2 = ([System.Net.IPAddress]$end).GetAddressBytes() [Array]::Reverse($ip2) $ip2 = ([System.Net.IPAddress]($ip2 -join ‘.’)).Address for ($x=$ip1; $x…

Read More

printDiv

Posted on

function printDiv(divName) { var printContents = document.getElementById(divName).innerHTML; var originalContents = document.body.innerHTML; document.body.innerHTML = printContents; window.print(); document.body.innerHTML = originalContents; } <input type=’button’ value=’Print This Only’ onclick=’printDiv(example);’/> Originally Posted on February 21, 2013Last Updated on October 26, 2015 All information on this site is shared with the intention to help. Before any…

Read More