LinkBack URL
About LinkBacks
Sorry, I missunderstood...
Does this help:
Formula:
=FORECAST(A2,OFFSET(C2,MATCH(A2,C:C,1),1,2),OFFSET(C2,MATCH(A2,C:C,1),,2))
Sorry, I missunderstood...
Does this help:
Formula:=FORECAST(A2,OFFSET(C2,MATCH(A2,C:C,1),1,2),OFFSET(C2,MATCH(A2,C:C,1),,2))
Never use Merged Cells in Excel
However, this doesnt work when I try to put the formula in another worksheet, I use:
=FORECAST(AY8,OFFSET('MID-SWAP Curve'!$C$2,MATCH(AY8,'MID-SWAP Curve'!$C$3:$C$36,1),1,2),OFFSET('MID-SWAP Curve'!$C$2,MATCH(AY8,'MID-SWAP Curve'!$C$3:$C$36,1),,2))
Somehow the match function gives N/A
Ideas?
It works! However, this doesnt work when I try to put the formula in another worksheet, I use:
=FORECAST(AY8,OFFSET('MID-SWAP Curve'!$C$2,MATCH(AY8,'MID-SWAP Curve'!$C$3:$C$36,1),1,2),OFFSET('MID-SWAP Curve'!$C$2,MATCH(AY8,'MID-SWAP Curve'!$C$3:$C$36,1),,2))
Somehow the match function gives N/A
Ideas?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks