How do I autofill the following formula =INDEX('Zip
Data'!A1:H41576,MATCH(E2,'Zip Data'!A1:A41576,0),5)?

I have used the $ signs and for some reason it doesn't return the correct
match.

I have to match data for over 41k cells.

Thanks