About
Pricing
Community
Teams
Start Free Trial
Log in
James Murrell
asked on
10/22/2015
Excel i need to lookup names between two sheets
hi hope you guys can help i have brain freeze at the mo
i have a list of accounts number that i need to lookup names
so on sheet 1 i have
a
74921101
74922331
74922331
74922461
74922461
74927161
74927161
74927171
74927171
844533551
and on sheet 2 i have
a b
74921101 company a
74922331 company b
74922461 company c
74927171 company d
844533551 company e
what I want is on sheet 1 cell b to show sheet 2 b name
a b
74921101 company a
74922331 company b
74922331 company b
74922461 company c
74922461 company c
Hope this all makes sense
James
Microsoft Excel
4
1
Last Comment
Professor J
8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Rob Henson
10/22/2015
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
James Murrell
10/22/2015
ASKER
big thanks
Roy Cox
10/22/2015
Use Tables to simplify formula writing, also use ISERROR to avoid error messages
VLOOKUP.xlsx
Professor J
10/22/2015
good to see your Rob. you catch the questions on the fly :-)
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck