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 |
Help - If statement in cell
c2=if(vlookup(a2,SOURCE,2,0)="",vlookup(a2,SOURCE, 1,0),vlookup(a2,SOURCE,2,0))
"Denis" дÈëÏûÏ¢ ... 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 |
Help - If statement in cell
Thanks Evan
"Evan Lee" wrote in : c2=if(vlookup(a2,SOURCE,2,0)="",vlookup(a2,SOURCE, 1,0),vlookup(a2,SOURC E,2,0)) |
All times are GMT +1. The time now is 09:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com