There are 2 sets of data:
1st set comprises columns A B C
2nd set comprises column D
Columns A&B are min and max values in a range. Each range per row is specific in that it can not appear in another row.
Column C is a name associated with that range(A&B).
Column D is a set of data that needs to search against all the columns in all the rows and if it appears within any range then the Column C content will appear (IF..THEN statement)in column E
colA,colB,colC,colD
1,4,white,3
5,7,pink,4
9,11,blue,8
12,15,orange,11
Many thanks in anticipation.
1st set comprises columns A B C
2nd set comprises column D
Columns A&B are min and max values in a range. Each range per row is specific in that it can not appear in another row.
Column C is a name associated with that range(A&B).
Column D is a set of data that needs to search against all the columns in all the rows and if it appears within any range then the Column C content will appear (IF..THEN statement)in column E
colA,colB,colC,colD
1,4,white,3
5,7,pink,4
9,11,blue,8
12,15,orange,11
Many thanks in anticipation.