SOLVED

# Autofill from different workbook based on unique ID to separated cells

Copper Contributor

# Autofill from different workbook based on unique ID to separated cells

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

# Re: Autofill from different workbook based on unique ID to separated cells

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))

# Re: Autofill from different workbook based on unique ID to separated cells

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!

1 best response

Accepted Solutions
best response confirmed by Chris_George (Copper Contributor)
Solution

# Re: Autofill from different workbook based on unique ID to separated cells

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))