Word type document auto fill in

Hi, welcome to the forum

You can probably do this with a table of all your data, then use VLOOKUP or INDEX/MATCH to bring in the necessary data.

As suggested, can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Hi, welcome to the forum

You can probably do this with a table of all your data, then use VLOOKUP or INDEX/MATCH to bring in the necessary data.

As suggested, can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

As you said, that is mail-merge, or at least, am image, so cannot work with that.

Here is how it would be done though...

	N	O	P	Q	R
15	ID	222222
16
17	Division	Department	Emplid#	Name	Position
18	Human Resources	Compensation & Benefits	222222	Jane Doe	Manager

If you put your ID in O15 (or wherever you need it to be), then you would use a formul;a like this to get the data...
N18=INDEX('Master File'!$A$2:$E$6,MATCH(Letter!$O$15,'Master File'!$C$2:$C$6,0),MATCH(Letter!N$17,'Master File'!$A$1:$E$1,0))

You would put this wherever you need *that* piece of info to appear

I would use mail merge in word with Excel as the source table
https://youtu.be/IlJ5uC4O-sE