Autofill Match Formula on different worksheets

[Guest]

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

 

[Guest]

Hi
If you insert the dollar signs as follows, this should work:
=INDEX('Zip

Data'!$A$1:$H$41576,MATCH(E2,'Zip Data'!$A$1:$A$41576,0),5)

You may also need a dollar sign on the "E2" depending on where you are
copying from and to...

 

[Guest]

Hi
If you insert the dollar signs as follows, this should work:
=INDEX('Zip

Data'!$A$1:$H$41576,MATCH(E2,'Zip Data'!$A$1:$A$41576,0),5)

You may also need a dollar sign on the "E2" depending on where you are
copying from and to...