Hello,
I have 2 workbooks. One is a the form to be filled out and the other is the data sheet. I'm trying to pull all the header information (ex name, address, SIN, etc) into the form. The key field to match is the client account number (H12).
By typing in the reference here, I'm hoping the rest of the fields above populates. I think index match would work but can't get the right formula. As a test I'm playing around with just trying to get the social insurance number to populate.
On the data book this is in column AD. Please note this is the form is protected so some fields are locked.
Any help would be appreciated
Bookmarks