Tell me more ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
up vote 1 down vote favorite

I'm using the following formula in Excel 2010:

=IF(ISERROR(MATCH(C7,$C$2,0)),"",E7)

When I use Ctrl+D or Fill down the $C$2 reference fails to "increment".

Is there any way to fix this?

share|improve this question
Do you mean 'repeat' or 'increment'? The $ signs mean that a filled formula will always reference that particular column and/or cell. – foocode Jul 9 '12 at 23:04
@foocode increment (sorry) – toomanyairmiles Jul 9 '12 at 23:24
1  
@toomanyairmiles Remove the '$'s - they are telling Excel not to increment - it is their sole purpose. – Paul Jul 9 '12 at 23:29

1 Answer

up vote 3 down vote accepted

Try it without the $ signs before the C & the 2. The $ signs act as a hard pointer so the formula currently includes an absolute (static) reference to cell C2.

If you just have 'C2' instead of '$C$2' i.e. a relative reference, when the formula is filled-down it'll increment to D2, E2 and so on.

share|improve this answer
2  
Further details here. Also, please add the terms relative and absolute to your answer, easier to search ;) – Bob Jul 9 '12 at 23:38

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.