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