Hello and thank you for any help. I am trying to perform a vlookup, nested with an if statement. I am very familiar with this basic process. My problem however arrises when I try to use an OR statement as the first condition within the IF statement. Essentially what I am trying to ask excel to do is..."If you find an error OR a 0 in cell Y35, perform this vlookup statement, else return the value in cell Y35" I have had success performing this process when just using the ISERROR statement as the first condition in the IF statement and when using just the =0 condition, but I have not been able to get both of them to work at the same time. Here is what my formula looks like currently but it does not work.
=IF(OR(ISERROR(Y35),Y35=0),VLOOKUP(R35,'Volume Table'!$A$1:$B$60,2,FALSE)/S35,Y35)
I have done my best to describe this so if you need further details let me know. Thanks
=IF(OR(ISERROR(Y35),Y35=0),VLOOKUP(R35,'Volume Table'!$A$1:$B$60,2,FALSE)/S35,Y35)
I have done my best to describe this so if you need further details let me know. Thanks