Autofill Match Formula on different worksheets
 

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

Autofill Match Formula on different worksheets
 

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...
--
Penny at <a
href="http://www.easypctraining.com.au"www.easypctraining.com. au</a


"Bmoney" wrote:

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