Get-ID.xls

Get-ID.xlsx

<div>
<div class="content wysiwyg-content">
I have one spreadsheet with two tabs<br />
<br />
USPS Employees<br />
users<br />
<br />
In USPS Employees I have a bunch of columns but the key ones are<br />
<br />
B - SFDCID<br />
F - Email<br />
<br />
on the second tab users the key columns are <br />
<br />
A - ID<br />
Q - email<br />
<br />
what I would like to do is fill USPS Employees (Column B) SFDCID with column A from users when USPS Employees (Column F) = users (Column Q)
</div>
</div>


I have one spreadsheet with two tabs

USPS Employees
users

In USPS Employees I have a bunch of columns but the key ones are

B - SFDCID
F - Email

on the second tab users the key columns are 

A - ID
Q - email

what I would like to do is fill USPS Employees (Column B) SFDCID with column A from users when USPS Employees (Column F) = users (Column Q)

Another Excel Lookup Question

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.