SOLVED

Autofill from different workbook based on unique ID to separated cells

New Contributor

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:

Sample_Data.png

 

Example printout (located in a separate workbook):

Printout_Screen.png

 

PC: Windows 11

Excel: Microsoft 365 Excel for Desktop (Version 2112)

2 Replies
best response confirmed by Chris_George (New Contributor)
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))

 

@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!