I have this worksheet which contains a single column of values. The values in this column are those "studies" which i want to exclude from my calculations.

I have another worksheet which references this studies_to_exclude sheet/column

IF(ISERROR(VLOOKUP(A2,Study_Exclusion!C:C,1,FALSE)),"Include","Exclude")

I know referencing an entire column in this way is not the best way to do things.....i was wondering how else to do it......ie the reference Study_Exclusion!C:C ....is bad practice.

Any suggestions?