Joined: 25 May 2002
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
Many thanks in anticipation.