SOLVED IF Function Question maybe -Autofilling account numbers to...

Name		Date         	Account		Product			Status
Ferreira	1/11/2016	Aquidneck	Bombay			Pending
Ferreira	1/11/2016	Capital		Jager counter freezer	Pending
Ferreira	1/11/2016	City Liq	Harpoon Cold Box	Pending
Robinson	1/11/2016	Heritage	Mezzacorona		complete
Robinson	1/12/2016	Heritage	Miller Lite		complete
King	        1/11/2016	Exeter		Harpoon Cold Box	Pending

This is an example of the document I work with everyday. It is a booking sheet for my display team. My boss has asked me to include account numbers next to each account name. I do have a master excel list with all account names and corresponding account numbers. Is there a way that I can save all of the account names and numbers in excel's memory, so that I when I start typing an account name, the account number will autofill to the next column. I do not want to have to manually look up each account number and type it in. Does that make any kind of sense? Any help would be much appreciated. Thanks so much.