Autofill Match Formula on different worksheets

B

Bmoney

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
 
E

EasyPC Training

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)
Click to expand...

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