View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Denis[_8_] Denis[_8_] is offline
external usenet poster
 
Posts: 3
Default Help - If statement in cell

I need help. I am pulling data from another spreadsheet using VLookUp.
The data is in two columns side by side. Some of the data comes back with
a 0 as the cell it is searching is empty.

I am trying to put an If statement in a third column to copy the cell with
a value and ignore the cell with a 0. EXCEPT that when there is a non 0
value in the second column.

Example

25 0 25
12 0 12
25 12 12

I hope someone can help.

Thanks,

Denis