Rubber Beaked Woodpecker
Board Regular
- Joined
- Aug 30, 2015
- Messages
- 203
- Office Version
- 2021
I have the following customer database:
Column A1:A600 - Customers Name
Column B1:B600 - Customers Address
Column C1:C600 - Customers account number
I would like to a formula so that if a account number is entered into D1 it would lookup the database and enter the customers name into E1 and the customers address into F1.
I believe this would require a VLOOKUP formula but cannot get this to work. This has to be a formula and not VBA.
Any advice please
Thank you RBW
Column A1:A600 - Customers Name
Column B1:B600 - Customers Address
Column C1:C600 - Customers account number
I would like to a formula so that if a account number is entered into D1 it would lookup the database and enter the customers name into E1 and the customers address into F1.
I believe this would require a VLOOKUP formula but cannot get this to work. This has to be a formula and not VBA.
Any advice please
Thank you RBW