# If or/and statement

This is a discussion on If or/and statement within the Excel Questions forums, part of the Question Forums category; I need help with a code so that if the lookup in W returns any value other than zero, it ...

1. ## If or/and statement

I need help with a code so that if the lookup in W returns any value other than zero, it leaves X blank. If the lookup in W returns 0 then X=0

 * W X 1 Tight Net Tight Net Rolls 2 3.25 5 3 2.25 3 4 0 0 5 0 0

 Cell Formula W2 =IF(VLOOKUP(C2,Table1,20,FALSE),VLOOKUP(C2,Table1,20,FALSE),0) W3 =IF(VLOOKUP(C3,Table1,20,FALSE),VLOOKUP(C3,Table1,20,FALSE),0) W4 =IF(VLOOKUP(C4,Table1,20,FALSE),VLOOKUP(C4,Table1,20,FALSE),0) X4 =IF(Table2[[#This Row],[Tight Net ]]=0,0,ISBLANK) W5 =IF(VLOOKUP(C5,Table1,20,FALSE),VLOOKUP(C5,Table1,20,FALSE),0)

Excel tables to the web >> Excel Jeanie HTML 4

2. ## Re: If or/and statement

=IF(VLOOKUP(C2,Table1,20,FALSE)<>0,"",0)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•