hi,
this isn't working, should there not be a reference to sheet 1 where the
data to be matched is? also the doc no: will change as you move down the
column.
Thanks

"JE McGimpsey" wrote:

One way:

=IF(ISNA(MATCH("V009",Sheet2!E:E,FALSE)), "", VLOOKUP("V009",
Sheet2!E:G,2,FALSE) + VLOOKUP("V009",Sheet2!E:G,3,FALSE))




In article ,
Haz wrote:

i'm looking for a countif function I think for the following :
Col E sheet 2 Col F sheet 2
doc no AMT
V009 £500

I want to search for this data in sheet 1 and return the result if there is
an exact match...Where
Col H sheet2
Doc No: ( if there is V009 in this column.........then return the AMT in
either Column F or G. One of these amounts is always '0' so which ever is 0
in F or G sheet 2.
is this possible with count if ?
Hope this is clear
any help would be appreciated Thanks in advance.