Autofill Match Formula on different worksheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bmoney - 18 Aug 2006 23:12 GMT

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

Reply to this Message

EasyPC Training - 19 Aug 2006 04:01 GMT

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...

Signature

Penny at <a
href="http://www.easypctraining.com.au">www.easypctraining.com.au</a>

> How do I autofill the following formula =INDEX('Zip
> Data'!A1:H41576,MATCH(E2,'Zip Data'!A1:A41576,0),5)?
[quoted text clipped - 5 lines]
>
> Thanks

Reply to this Message