Auto Populate cell based on Drop Down list in another cell (VLookup)

Hello Everyone,

I know this question has been asked, but the suggested answers are not working to solve my issue. I have tried time and again to use VLOOKUP with moderate success and, after about two hours, I only just now got a value.

What I am trying to do is have the corresponding LEA Number from the sheet called LEA Information generate in cell H6 when the district is selected from the list. As you can see from the attached workbook, the formula that I used is "=VLOOKUP(C6,LEAInformation,1,TRUE)" but the problem is that when I select a different district name from C6, the LEA number does not change and it does not correspond to the district either. Please help, I feel like an absolute imbecile.

Attached you will find the workbook that I am dealing with:

On Sheet 1 in cell C6 is a dropdown menu using the data range from the second sheet (LEA Information) called LEANames.

Quick Info for sheet "LEA Information":

• A2:261 is called LEANumbers.
• B2:261 is called LEANames.
• The Table Array is called LEAInformation.