Link to home
Start Free TrialLog in
Avatar of WeThotUWasAToad
WeThotUWasAToad

asked on

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

Hello,

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)

Open in new window

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
Avatar of Ejgil Hedegaard
Ejgil Hedegaard
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial