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)
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)
Who is Participating?
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.
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