Autofill from different workbook based on unique ID to separated cells

[Chris_George]

Hello Excel Experts!

Situation:

I have two separate workbooks. One will hold the data in a standard table format. The other will be for printing out customer information. In the printout the customer data will be located in various cells around the sheet.

Expected Result:

I would like to be able to input the Student ID (yellow fill) into the printout sheet and the data would auto-populate into the cells (blue fill) on the printout sheet.

Example data workbook:

Example printout (located in a separate workbook):

PC: Windows 11

Excel: Microsoft 365 Excel for Desktop (Version 2112)

[#2 · Accepted solution]

@Chris_George 

Hello,

Attached is an excel file with a formula that I think might work,

=INDEX($B$2:$F$5,MATCH($C$8,$A$2:$A$5,0),MATCH(B10,$B$1:$F$1,0))

[#3]

@alannavarro 

That was exactly what I needed!! It works like a charm on my workbooks.

Since I think I will be using this formula quite a bit, I will dive into the logic but I now know how to use it on a surface level.

Thanks again!