How to Use An RFID Scanner with Excel To Perform A Missing Inventory Audit
By: POSGuys Support - 4/5/2024

<div class="Dynamic-Two-Column-Row2ColumnReverse" style="max-width: 100%; display: flex;">
<div class="FeatureHighlight50-100" style="width: 100%;"> <span style="font-size: 200%; color: #287a9b;"><strong>Overview</strong></span>
<p>If you are looking for a convenient, lightweight approach to RFID, you can use Microsoft Excel to compare your scan results against an existing list- no expensive specialty software required.</p>
<p>In this scenario, you would import or create a list of existing RFID Values into a single column. You would then have a second column to scan your RFID Tags into, populating your second list. Lastly, you will have a third column comparing your scanned list against the first column and highlighting any missing values.</p>
<p>This process will allow you to quickly determine if any of your products or assets are missing from an existing list with a single walkthrough. From there, you can begin looking into finding your missing product.</p>
<p>This solution is ideal if you're looking to do a quick spot check of missing items from a relatively small inventory. Depending on the size of your inventory and warehouse, a more purpose-built solution might be needed.&nbsp;If you're interested in purchasing an RFID Reader or exploring RFID implementation, our experienced team can guide you through the options and connect you with the right technical resources. Reach out to us directly for a Free Consultation.</p>
<div style="margin-top: 2%; flex-wrap: wrap; display: flex;" class="CTAHighlightBoxWithLeftImage"><img src="https://posguys.blob.core.windows.net/content/images/blog/82926/RP902MFi.png" alt="Placeholder image" style="align-self: center; width: 186px; margin-right: 2%; margin-bottom: 2%;" />
<div style="width: 75%;">
<p style="display: flex; line-height: 100%;"><b>Need An Affordable RFID Scanner?</b></p>
<p style="line-height: 100%;">The Unitech RP902 is one of our most cost-effective RFID scanners and is perfect for people looking to get started without making a big up-front investment.</p>
<div class="DynamicTwoColumnParagraphsItems" style="width: 300px;"><a href="/mobile-barcode-scanner_67/UniTech-RP902_3915/"> <input type="submit" value="BUY THE RP902" class="btn btn-large btn-success" style="padding: 12px; background-color: #f75800; border-color: #f75800; white-space: normal; word-wrap: break-word; border-radius: 6px; width: 200%; margin-bottom: 10px;" /></a></div>
</div>
</div>
</div>
<div style="display: flex; flex-direction: column; flex-wrap: wrap; align-items: flex-start; margin: 15px; align-content: center;"><img title="RFID Excel Template Example." src="https://posguys.blob.core.windows.net/content/images/blog/82926/RFID_missing_values.jpg" alt="RFID Excel Template Example" width="100%" /></div>
</div>
<p><span style="font-size: 200%; color: #287a9b;"><strong>How to Setup Your Excel Document</strong></span></p>
<p>In this walkthrough, we are using the <b>VLOOKUP</b> formula together with the <b>IF</b> and <b>ISNA</b> Functions.</p>
<p>Here is the formula in the sample spreadsheet to the right, written in <b>Column E, Cell 3:</b> <br />&emsp;&emsp;<em>=IF(ISNA(VLOOKUP(A3:A22, C3:C22, 1, FALSE)), A3:A22, "")</em></p>
<div style="display: block; padding: 1%; margin-left: 5%; width: 30%;"><img title="Formula Screen Grab" width="100%" src="https://posguys.blob.core.windows.net/content/images/blog/82926/RFID_Formula.jpg" /></div>
<div style="clear: left;"><ol>
<li style="font-weight: bold; font-size: larger;"><span style="font-weight: normal;">Start by writing this Formula:</span> <br /><span style="font-weight: strong;">&emsp;&emsp;&emsp;&emsp;=IF(ISNA(VLOOKUP(</span></li>
<li style="font-weight: bold; font-size: larger;"><span style="font-weight: normal;">The next part is your Existing Inventory List which is defined by the range of cells your list is on:</span> <br /><span style="font-weight: normal;">&emsp;&emsp;&emsp;&emsp;=IF(ISNA(VLOOKUP(<b>A3:A22, </b>)</span></li>
<li style="font-weight: bold; font-size: larger;"><span style="font-weight: normal;">The next set to be defined is the New List that you generate through your scans:</span> <br /><span style="font-weight: normal;">&emsp;&emsp;&emsp;&emsp;=IF(ISNA(VLOOKUP(A3:A22, <b>C3:C22,</b>)</span></li>
<li style="font-weight: bold; font-size: larger;"><span style="font-weight: normal;">After the new list is defined, you will enter a value of 1. Since we are using just one column, a value of 1 is all that is needed:</span> <br /><span style="font-weight: normal;">&emsp;&emsp;&emsp;&emsp;=IF(ISNA(VLOOKUP(A3:A22, C3:C22, <b>1,</b>)</span></li>
<li style="font-weight: bold; font-size: larger;"><span style="font-weight: normal;">Now, we will use FALSE after specifying one column. This ensures an exact match of values. Be sure to use two closing parentheses after defining FALSE. </span> <br /><span style="font-weight: normal;">&emsp;&emsp;&emsp;&emsp;=IF(ISNA(VLOOKUP(A3:A22, C3:C22, 1, <b>FALSE))</b>)</span></li>
<li style="font-weight: bold; font-size: larger;"><span style="font-weight: normal;">Here, we will once again reference your Existing Inventory List:</span> <br /><span style="font-weight: normal;">&emsp;&emsp;&emsp;&emsp;=IF(ISNA(VLOOKUP(A3:A22, C3:C22, 1, FALSE)), <b>A3:A22,</b>)</span></li>
<li style="font-weight: bold; font-size: larger;"><span style="font-weight: normal;">Finally, we will use two double quotes to create the blank spaces in our Comparison Column.</span> <br /><span style="font-weight: normal;">&emsp;&emsp;&emsp;&emsp;=IF(ISNA(VLOOKUP(A3:A22, C3:C22, 1, FALSE)), A3:A22, <b>"")</b>)</span></li>
<ol type="A">
<li style="font-weight: bold; font-size: larger;"><span style="font-weight: normal;">Note, you can enter text within the two double quotes. See below for an example.</span> <br /><span style="font-weight: normal;">&emsp;&emsp;&emsp;&emsp;=IF(ISNA(VLOOKUP(A3:A22, C3:C22, 1, FALSE)), A3:A22, <b>"Found")</b>)</span></li>
</ol></ol></div>
<div style="display: block; float: left; padding: 1%; margin-left: 5%;"><img title="Found Screen Grab" width="100%" src="https://posguys.blob.core.windows.net/content/images/blog/82926/RFID_Found.jpg" /></div>

<div style="background-color: rgba(105, 167, 191, .3); display: flex; justify-content: center; align-items: center; padding: 1%; width: 100%; line-height: 175%; height: 70px;"><strong><span style="font-size: 250%; display: block; text-align: center;">Have a Question? We can help!</span></strong></div>
<p><iframe style="width: 100%; height: 900px;" src="/Forms/ConsultSignupWarehouseManufacturing" frameborder="0" scrolling="yes"></iframe></p>
<style><!--
.CTAHighlightBoxWithLeftImage {
        padding: 15px 12px 15px 12px;
        display: flex;
        border-color: #6c757d;
        flex-direction: row;
        flex-wrap: wrap;
    }

.DynamicTwoColumnParagraphsItems {
        width: 48%;
    margin: 3% 15px 3% 0px;
}

.Dynamic-Two-Column-Row2ColumnReverse {
        display: flex;
        flex-direction: row;
        justify-content: center;
    }

.FeatureHighlight50-100 {
        display: flex;
        flex-direction: column;
        justify-content: space-evenly;
        flex-wrap: wrap;
        align-items: flex-start;

align-content: flex-start;
        width: 50%;
    }

@media (max-width: 1025px) {

.CTAHighlightBoxWithLeftImage {
            flex-direction: column;}

.DynamicTwoColumnParagraphsItems {
    width: 95%;}

.Dynamic-Two-Column-Row2ColumnReverse {
            text-align: Center;
            width: 100%;
            flex-direction: column-reverse; }

.FeatureHighlight50-100 {
            width: 95%;
        }

}
--></style>

How to Use An RFID Scanner with Excel To Perform A Missing Inventory Audit By: POSGuys Support - 4/5/2024

Recent Posts By POSGuys Support

How to Use An RFID Scanner with Excel To Perform A Missing Inventory Audit
By: POSGuys Support - 4/5/2024