Let us say G.Anderson appears in K1 of Sheet2. Now you want to see if
the combination G.Anderson with any of the Applications appearing next
to G.Anderson in Sheet2 also appears in Sheet1?

Try the following *array* formula (commit with Shift+Ctrl+Enter)

=IF(ISNUMBER(MATCH(K1&$B$2:$B$14,Sheet1!$A$2:$A$14 &Sheet1!$B$2:$B$14,0)),"match","no
match")

Does this help?
Kostis Vezerides


wrote:
thank you, but unfortunately that only seems to return a match if the
value in the column b is presernt anywhere in the range of column b on
worksheet2.

here is some sample data:

Name Application
G.Anderson VB6
G.Anderson Team Spirit
B.Jones MapManager/Editor
A.Smith Groupwise 5.5

assuming name is column A and Application is column B. these are like
records so to speak. So where a name appears in column A on worksheet
one I need to check to see if it appears in worksheet two. And if it
does then see if one of the application name's that is next to it in
worksheet 1 column b also appears next to it on worksheet 2 column b.
Been trying to do this for 4 days now and all i get is errors :'(.