View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sedonovan
 
Posts: n/a
Default help with formula...if -- concatenate

=IF(A4<"","=CONCATENATE(sheet1!A4,sheet2!B4,"txt" )","")

is this possible?

where am I going wrong?

sorry to be a pain!