Another Excel Lookup Question

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)
Matt PinkstonAsked:
Who is Participating?
 
redmondbConnect With a Mentor Commented:
Hi,  pinkstonmp.

Please see attached.  Which version of Excel are you using? If it's 2007 or higher then there's a much more efficient formula.

Regards,
Brian.Get-ID.xls
0
 
redmondbCommented:
... and here it is...Get-ID.xlsx
0
 
redmondbCommented:
Thanks, pinkstonmp.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.