The formula below works perfectly. I am hoping to add one additional condition it that basically tells the formula to run or not to run at all.
The table in the formula below is used for lookup is in column A of the “Table” worksheet (cells A2 to A30.
On the “Table” worksheet, in column “X” if the word “No” appears, then the formula is not run. But if the cell in “X” is blank, then the formula runs as it currently does. So, the logic that I need to add is if a cell in “X” has the value of “No”, then do not run the formula.
I apologize if this is too wordy or is confusing. I tried my best to word it as accurately as possible.
=IF(OR(C200<1,A200=0),"",IFERROR(LOOKUP(2^15,SEARCH(Table!$A$2:$A$30,A200),Table!$A$2:$A$30),""))
The table in the formula below is used for lookup is in column A of the “Table” worksheet (cells A2 to A30.
On the “Table” worksheet, in column “X” if the word “No” appears, then the formula is not run. But if the cell in “X” is blank, then the formula runs as it currently does. So, the logic that I need to add is if a cell in “X” has the value of “No”, then do not run the formula.
I apologize if this is too wordy or is confusing. I tried my best to word it as accurately as possible.
=IF(OR(C200<1,A200=0),"",IFERROR(LOOKUP(2^15,SEARCH(Table!$A$2:$A$30,A200),Table!$A$2:$A$30),""))
