How to Auto fill a cell in sheet 1 from two columns of data in sheet 2

PnWMika99

New Member
Joined
May 18, 2023
Messages
1
Office Version
  1. 365
Platform
  1. Windows
I would like to be able to type in data in sheet 1 cell (A2 as an example) but have this data be auto pulled and filled from info in sheet 2 as I type it in.

So sheet 1 A's header is named "institution", to be autofilled as I type something in these cells pulled from sheet 2, column A.

When I would like sheet 1 column B named "CEEB" would be auto filled based on the name of the college entered into column A.

E.g., when I enter in "Michigan State University" into sheet 1's cell, I would like this to be auto filled from sheet 2 so I don't have to type the whole thing. What I also need is then for column B named CEEB to auto enter in the CEEB code of 1465 corresponding to Michigan State University from sheet 2.

We have over 5000 names and ceeb codes that I would like to do this from. I have uploaded an image from sheet 2. Sheet 1 is of course blank with just headers "institution" and "CEEB". I am new to Excel so any help would be helpful. Couldn't find much info online.

Thank you in advance.
 

Attachments

  • Sheet1.PNG
    Sheet1.PNG
    14.8 KB · Views: 15
  • Sheet2.PNG
    Sheet2.PNG
    79.8 KB · Views: 16

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Forum statistics

Threads
1,213,510
Messages
6,114,040
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top