Since you didn't reply to the message with the "this" you refer to, I
can't tell what the problem is.

You can use COUNTIF() if you want, rather than ISNA(MATCH()), but
there's no real advantage to doing so. You'll still need to do a couple
of VLOOKUP()s to return the values you want.


In article ,
Haz wrote:

Thanks for getting back to me, when i do this it says your missing a
parethess--) not sure what this is. However, i've been able to match the
document numbers up by using a count if function:
=IF(COUNTIF(Sheet3!$A:$A,A2),A2,"") I now want to check if the totals agree
in two different worksheets.
Sheet 2 Match with: sheet 1
col E col f or col G where 1 of this is
always Zero, so return
Amt value 0 from either

Is there a simpler solution to this?