I wrote a formula, and it works perfectly, only now I have to integrate one more factor into it, and I cannot seem to get it to work. My formula is (which resides in cell B40):
=IFERROR(IF(VLOOKUP($E1,Calc_Table,22,FALSE)=0,0,VLOOKUP($E1,Calc_Table,22,FALSE)),"-")
I need to add in if the value from the "Calc_Table" (column 22) happens to be 2 or greater, than I need "-" to display in the cell. I was able to get it to work in the first cell, but when the value was 1, it still displayed "-", which is wrong. I know the answer is something simple, I just cannot figure it out, any help is appreciated. Thanks so much!
Bookmarks