• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 302
  • Last Modified:

If formula with a range of data

This is my formula: =IF(B2='Control Stores'!B2,"control", "test") I have a list of control stores in the control stores tab B2:B341. How can I incorporate this range into my original formula?
0
Ladkisson
Asked:
Ladkisson
1 Solution
 
Shanan212Commented:
So do you want to see if 'B2' is in the range on the other sheets?

One way is

=IF(COUNTIF('Control Stores'!$B$2:$B$341,B2)>0,"Control","Test")

Open in new window

0
 
LadkissonAuthor Commented:
Thank you!
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now