• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 274
  • Last Modified:

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)
0
Matt Pinkston
Asked:
Matt Pinkston
  • 3
1 Solution
 
redmondbCommented:
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now