imported_unknown
Active Member
- Joined
- Jan 13, 2002
- Messages
- 424
I am trying to return values in a row based on values in three columns. The data is not sequential because the columns represent non sequential data. For example column a holds the plant code id number, column b holds the assembly line number and column c holds the date referenced. Columns a and b will repeat based on the value in column c. Columns d thru l contain information relevant to the first three columns. I would like to be able to get a value from column f based on meeting the criteria in columns a,b and c. If I have unique values in column a or b or c I can do this. The problem is that these values repeat. I am looking for a unique set of three values not 1. Can anyone point me in the right direction?