asked on Check Excel cell from a range
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),"Ye
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),"Ye
But Instead I am getting now on row 5 =IF(COUNTIF(F4:F14,C5),"Ye
Is there an alterante solution?
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),"Ye
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),"Ye
But Instead I am getting now on row 5 =IF(COUNTIF(F4:F14,C5),"Ye
Is there an alterante solution?
Microsoft ExcelMicrosoft Office
Last Comment
Ryan Chong
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.