Excel – VLookup – Compare Two Columns/Sheets

Posted on By David Kittell

Sometimes we need to compare lists in Excel, this function will assist in getting a clean comparison.

NOTE: It is best when comparing that all columns are same format (ie. Text, Number, etc.)

=IF(ISERROR(VLOOKUP(A1,Sheet1!$A$1:$A$3,1,FALSE)),"MISSING FROM OTHER SHEET","")
' OR
=IF(ISERROR(VLOOKUP(A1,Sheet1!$A:A,1,FALSE)),"No","Yes")

Going one step further, if you find a match and need a value from the other worksheet you can do this.
In this example the 2 grabs the value from Worksheet2!B

=IF(ISERROR(MATCH(B3,Worksheet2!A:A, 0)), "No Match", VLOOKUP(B3,Worksheet2!A:B,2,FALSE))
Originally Posted on January 6, 2015
Last Updated on August 15, 2019
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

Filter Datagrid

Posted on

If you already have a data grid and want to search it you can create a textbox and do a textbox.textchanged control to run something like below: YourGridViewBindingSource.Filter = String.Format("YourDBColumn Like ;’*" & FilterValue) & "*’" Originally Posted on March 1, 2013Last Updated on October 26, 2015 All information on…

Read More

PowerShell – Get Text Encoding Type

Posted on

function Get-Encoding { param ( [Parameter(Mandatory,ValueFromPipeline,ValueFromPipelineByPropertyName)] [Alias(‘FullName’)] [string] $Path ) process { $bom = New-Object -TypeName System.Byte[](4) $file = New-Object System.IO.FileStream($Path, ‘Open’, ‘Read’) $null = $file.Read($bom,0,4) $file.Close() $file.Dispose() $enc = [Text.Encoding]::ASCII if ($bom[0] -eq 0x2b -and $bom[1] -eq 0x2f -and $bom[2] -eq 0x76) { $enc = [Text.Encoding]::UTF7 } if ($bom[0]…

Read More

Clean Up Database

Posted on

CAUTION: This is a very powerful script, use at your own risk! This script will: Drop all non-system stored procs Drop all views Drop all functions Drop all Foreign Key constraints Drop all Primary Key constraints Drop all tables USE <Database Name> /* Drop all non-system stored procs */ DECLARE…

Read More