software

These two (array) formulae seem to do the trick:

=IF(ISNA(MATCH(A2amp;B2,Sheet2!$A$2:$A$13 amp; Sheet2!$B$2:$B$13,0)),quot;Noquot;,quot;Yesquot;)

=IF(D2 = quot;Yesquot;,
IF(C2=INDEX(Sheet2!$C$2:$C$13,MATCH(A2amp;B2,Sheet2!$ A$2:$A$13amp;Sheet2!$B$2:$B$13,0)),quot;$okquot;,quot;$Noquot;),quot;quot;)

--
Kevin Vaughnquot;Mark Bquot; wrote:

gt; I need to get a formula for Col D in sheet 1 to tell me that for column A in
gt; Sheet 1
gt; Col B does have a matching TYPE in Sheet 2.
gt; And then, once that is established (or fixed), I need a formula for Col E
gt; which would test both Col A amp; Col B and confirm that Col C (Cost) matches.
gt;
gt;
gt; Sheet 1
gt; Col A Col B Col C Col D Col E
gt; Trip Type Cost
gt; A Single $100 Yes $ok
gt; A Quad $400 Yes $ok
gt; B Super $200 NO
gt; C Double $300 Yes $NO
gt;
gt; Sheet 2
gt; Col A Col B Col C
gt; Trip Type Cost
gt; A Single $100
gt; A Double $200
gt; A Triple $300
gt; A Quad $400
gt; B Single $100
gt; B Double $200
gt; B Triple $300
gt; B Quad $400
gt; C Single $100
gt; C Double $200
gt; C Triple $300
gt; C Quad $400
gt;
gt;
gt;