oliver_penney
Board Regular
- Joined
- Dec 18, 2002
- Messages
- 182
if i have a table
aaa1 bbb1 ccc1
aaa1 bbb2 ccc2
aaa2 bbb2 ccc3
how do i do a
DOUBLEMATCH(aaa2,bbb2)=ccc3
type of formula to give me the first instance of the third column where the first two columns match certain criteria?
thanx in advance
aaa1 bbb1 ccc1
aaa1 bbb2 ccc2
aaa2 bbb2 ccc3
how do i do a
DOUBLEMATCH(aaa2,bbb2)=ccc3
type of formula to give me the first instance of the third column where the first two columns match certain criteria?
thanx in advance