ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   use primary key to automatcally enter data across rows (https://www.excelbanter.com/excel-programming/374081-use-primary-key-automatcally-enter-data-across-rows.html)

glenn

use primary key to automatcally enter data across rows
 
I'm setting up a database. I want to be able to transfer data from another
sheet by using a primary key to enter information into cells across the row.
what is the formula?

Norman Jones

use primary key to automatcally enter data across rows
 
Hi Glenn,

I'm setting up a database. I want to be able to transfer data from another
sheet by using a primary key to enter information into cells across the
row.
what is the formula?


Check the VLookup function in Excel help.


---
Regards,
Norman




All times are GMT +1. The time now is 12:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com