Link to home
Create AccountLog in
Avatar of Matt Pinkston
Matt Pinkston

asked on

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)
ASKER CERTIFIED SOLUTION
Avatar of redmondb
redmondb
Flag of Afghanistan image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
... and here it is...Get-ID.xlsx
Thanks, pinkstonmp.