| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
The same formula doesn't work again?
Hey all, I have a workbook which contains allot of data which is all brought together on a front sheet via a drop down box and this formula: =INDEX(Data2!$C$2:$C$325,MATCH(INDEX(Reference!$B$ 2:$B$7,Reference!$C$9,1),IF(Data2!$B$2:$B$325= $A9, Data2!$A$2:$A$325),0)) its works perfectly... until I copy the workbook and refreash the data automatically. Does anyone know if I have to do something to activate this formula again? or can anyone think of a reason why it has stopped working when everything seems to be the same? Many thanks, Hayley -- Hru48 ------------------------------------------------------------------------ Hru48's Profile: http://www.excelforum.com/member.php...o&userid=24895 View this thread: http://www.excelforum.com/showthread...hreadid=553346 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change the work sheet name in a formula by using cell reference | Excel Worksheet Functions | |||
| Why does this Formula work? | Excel Worksheet Functions | |||
| Formula do not work until edited | Excel Discussion (Misc queries) | |||
| IF / VLOOKUP formula won't work until saved | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
