Form Based Index Match

[leebird]

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

[JeteMc]

Try pasting the following formula into Form N7:

Please Login or Register  to view this content.

Let us know if you have any questions.

[leebird]

That's perfect! Thank you so much

[JeteMc]

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.