Avatar of James Murrell
James Murrell
Flag for United Kingdom of Great Britain and Northern Ireland asked on

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

Avatar of undefined
Last Comment
Professor J

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Rob Henson

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

ASKER
big thanks
Roy Cox

Use Tables to simplify formula writing, also use  ISERROR to avoid error messages
VLOOKUP.xlsx
Professor J

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