I have a range of numbers which is a master list including 5000 numbers. We will call this master list "X".
I also have two more worksheets, each worksheet has another range of numbers, but it's a much smaller list. Keep in mind, I know these smaller lists are included in the master list.
We will call these two ranges "Y" and "Z". What I need to do is categorize which list it's coming from. I need to create a formula that will take the number from X, check Y, and if it's in Y it will produce a text of my choice. After I do that, I need to take the number from X, and check Z, if it's in Z it will produce another text of my choice.
X1 "Y"
X2 "Y"
X3 "X"
X4 "Y"
Appreciate any help,
Regards
Ghostcode
Something like:
=IF(ISNUMBER(MATCH(A1, ListX, 0)), "From List X", IF(ISNUMBER(MATCH(A1, ListY, 0)), "From List Y", IF(ISNUMBER(MATCH(A1, ListZ, 0)), "From List Z", "No Match")))
_________________
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!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks