I'd like to do a check where if the if statement finds either an #N/A or a 0 in a cell that has a formula in it where it pulls in various data (i.e. 0, 880, 880/886, ADL, etc.). There's some more stuff at the end that works fine...it's the beginning.
=IF(OR($J20=0,ISNA($J20)),Submissions!$J13,IF($O20="WPG",VLOOKUP($A20,OLD_W_ADL_Ven_NonOrderable!$A$2:$AH$65536,18,FALSE),IF($O20="DSD",VLOOKUP($A20,OLD_W_ADL_Ven_NonOrderable!$A$2:$AH$65536,30,FALSE),"FOB")))
This is what i have built so far and it gives me an #N/A instead of what I want. I had the form pulling in the data before correctly when i only had the ISNA part and didn't add in the OR. Like this:
=IF(ISNA($J20),Submissions!$J13,IF($O20="WPG",VLOOKUP($A20,OLD_W_ADL_Ven_NonOrderable!$A$2:$AH$65536,18,FALSE),IF($O20="DSD",VLOOKUP($A20,OLD_W_ADL_Ven_NonOrderable!$A$2:$AH$65536,30,FALSE),"FOB")))
Is it not possible to do it with an OR? How could I make it check for both options then before proceeding?
Bookmarks