hi, Can't get countif to work for me here,your right it'll have to be a
vlookup which i don't know much about. i'm typing in yours as this but it
says your missing a parenthesis--) ? this is what i'm putting in

=IF(ISNA(MATCH("e2",Sheet1!E:E,FALSE)), "", VLOOKUP(e2,
Sheet1!E:G,2,FALSE) + VLOOKUP("e2",Sheet1!E:f,3,FALSE))

where col E in sheet 2 contains the doc no which i'm trying to match in col
H in sheet 1 and then return the value in either column F or G also in sheet
1 depending on which is greater than 0.

Thanks for helping



"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.