Check Excel  cell from a range

Sam OZ
Sam OZ used Ask the Experts™
on
I need to check in an excel 2013 sheet the following
    Column  F has desired values  (in multiple rows)
     Column C has extracted values  (in multiple rows)

I need to make sure each cell in column c is one of the value in column F
I could try  formula  =IF(COUNTIF(F3:F14,C4),"Yes","No") in column D  and it works
But the problem is, When I copy formula to next row, say row 5 the range also increments
 On row 5, I SHOULD get =IF(COUNTIF(F3:F14,C5),"Yes","No")
But Instead I am getting now on row 5 =IF(COUNTIF(F4:F14,C5),"Yes","No")  - The range also increments after copy

Is there an alterante solution?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Software Team Lead
Commented:
try use $ sign in case you want to refer to fixed range.

see if this worked for you?

=IF(COUNTIF($F$3:$F$14,C4),"Yes","No")

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial