Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Lookup MATCH formula | Excel Discussion (Misc queries) | |||
Look for match on two worksheets | Excel Worksheet Functions | |||
formula adding cells in worksheets when # of sheets in work book changes | Excel Discussion (Misc queries) | |||
Find Matching Records in Two Worksheets | Excel Discussion (Misc queries) | |||
Formula Help With MATCH & OFFSET | Excel Worksheet Functions |