H
Haz
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.
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.