Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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. – Beeblebrox 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
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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .