What is an Excel formula that will tell you if the adjacent cell contains a value which is included in a defined range of values?
For example, suppose you have a range of cells ($F$2:$F$52) which contains 50 unique values. And suppose in column A, you have a list of several thousand values.
What formula in column B will tell you if the adjacent value in column A is one of the 50 unique values in column F?
I suppose you could accomplish it by using =VLOOKUP() in column B:
You would first need to place the value "Yes" in cells G2:G52, then use the (50 row x 2 column) range $F$2:$G$52. The resulting formula would be:
and the result in each row would be "Yes" or #N/A.
However, it seems like there should be a more direct formula which does not require the values in column G. Is that correct or is using the =VLOOKUP() method as good as any?