| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using AutoFilter to Sort Data Pulled in by INDEX / MATCH
You're welcome !
Glad to hear it sorted itself out <g -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "A Romeo Jr" wrote in message ... I just figured out the problem. If you look at the formula I pasted below, I reference cell E4 in the sheet titled "Summary" right after MATCH. Since the formula is in the "Summary" sheet, the formula only needs to go "MATCH(E4," . . . but since I was clicking back and forth between worksheets, it added the sheet name as well. Unfortunately this was the cause of the problem when I was using AutoFilter. After adjusting to your formula below, my worksheet now works! Thank you, Max, for your help! Greatly appreciated! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to sort data in worksheet by specific date | Excel Discussion (Misc queries) | |||
| Match and index functions: corrlating data from 2 worksheets | Excel Worksheet Functions | |||
| Index and Match issues | Excel Worksheet Functions | |||
| Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
| Data > Sort function amnesia? | Excel Discussion (Misc queries) | |||
Threaded Mode
