Excel  i need to lookup names between two sheets

James Murrell
James Murrell used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
Finance Analyst
Commented:
=VLOOKUP(Sheet1!A1,Sheet2!A:B,2,FALSE)
James MurrellProduct Specialist

Author

Commented:
big thanks
Roy CoxGroup Finance Manager

Commented:
Use Tables to simplify formula writing, also use  ISERROR to avoid error messages
VLOOKUP.xlsx
Professor JMicrosoft Excel Expert
Top Expert 2014

Commented:
good to see your Rob.  you catch the questions on the fly :-)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial