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
|