Hi, I have a workbook with 2 sheets. One is a database sent to me that contains BRANCH CODE and BRANCH columns:
The other is the sheet that I'll actually be working on:
So what I want to do is when I key in the number on the SITE COD columns, the SITE NAME column automatically gives me the BRANCH from the database.
I do know that I can use DGET by using multiple cells beyond my work space, and using those values on the SITE NAME columns. But is there a way for me to do it more easily? The reason why is that by the end of me working on this sheet, I'll have roughly 700 rows. I can't imagine having to manually assign cells for each DGET operation!
Thanks in advance.
The other is the sheet that I'll actually be working on:
So what I want to do is when I key in the number on the SITE COD columns, the SITE NAME column automatically gives me the BRANCH from the database.
I do know that I can use DGET by using multiple cells beyond my work space, and using those values on the SITE NAME columns. But is there a way for me to do it more easily? The reason why is that by the end of me working on this sheet, I'll have roughly 700 rows. I can't imagine having to manually assign cells for each DGET operation!
Thanks in advance.