book1.xlsx
Hello! New here but I've been creeping this place for the past 6 months or so but I finally found something that I can't figure out that I can't find an answer for....
I *think* I have attached a file. In column A:C are rows of departments class's and subclasses. In E:G there are more departments class's and subclasses. I need to figure a formula to determine if, for example, A1:C1 is anywhere in E1:G19??
Any Help would be greatly appreciated!
Put this formula in D1, then copy downward:
=ISNUMBER(MATCH(A1&"-"&B1&"-"&C1, INDEX($E$1:$E$19&"-"&$F$1:$F$19&"-"&$G$1:$G$19, 0), 0))
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Awesome! That did exactly what I was looking for. Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks