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

Red Hat / CentOS / Fedora – Splunk – PERL – Apache Server Status

Posted on

Guide Followed: https://community.splunk.com/t5/Getting-Data-In/Reading-Apache-server-status-output/m-p/48158 First make sure your Apache server-status is setup (assuming you already have Apache/httpd installed) # Create apache_exporter user sudo useradd apache_exporter -s /sbin/nologin # Create Apache Location declare apache_exporter=$(cat <<EOF ExtendedStatus on <Location /server-status> SetHandler server-status Order deny,allow Deny from all Allow from 127.0.0.1 </Location> EOF )…

Read More

Ektron Upload File Into Library

Posted on

I found and modified code to create an Ektron Library File Upload function. This function allows some customization: Defined Folder ID In this code I manually set the folder ID but effectively you could have a drop down list of folders to select the folder (see DMS Widget) Content Title…

Read More

MySQL Server Information

Posted on

SHOW VARIABLES; SHOW STATUS; select version(); SHOW STATUS provides server status information like Connections, Opened_tables, Bytes_received, Bytes_sent, etc. SHOW VARIABLES shows the values of MySQL system variables like time_zone, version, max_connections, etc. References: http://stackoverflow.com/questions/3939803/how-to-get-mysql-server-info-using-command-line All information on this site is shared with the intention to help. Before any source code…

Read More