WeThotUWasAToad

asked on

# Excel formula to determine if a given value is included in a defined range of cells

Hello,

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.

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:

Thanks

**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:

`=VLOOKUP(A2,$F$2:$G$52,2,0)`

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?**Thanks

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.