troubleshooting Question

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

Avatar of WeThotUWasAToad
WeThotUWasAToad asked on
Microsoft OfficeMicrosoft Excel
3 Comments3 Solutions34 ViewsLast Modified:

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?

Ejgil Hedegaard

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 3 Answers and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros