Hello,
I am trying to find the row number of a column that matches up with
given values in two cells, right now I accomplish this with a For loop
and check to make sure that it matches up. I would like to make it be
able to match up based on a list in column two. ie

Column 1 Column 2
1 1,2,3

Select if column 1 = 1 and Column 2 contains 2
Can this be done while making sure it doesn't select the row if column
2 contains the number 21?

Thanks in advance,
Josh

Just for reference, I found my answer at
http://www.ozgrid.com/forum/showthread.php?t=53095

jwh

Josh wrote:
Hello,
I am trying to find the row number of a column that matches up with
given values in two cells, right now I accomplish this with a For loop
and check to make sure that it matches up. I would like to make it be
able to match up based on a list in column two. ie

Column 1 Column 2
1 1,2,3

Select if column 1 = 1 and Column 2 contains 2
Can this be done while making sure it doesn't select the row if column
2 contains the number 21?

Thanks in advance,
Josh