Forum Discussion
Solved
Help with a formula.
I have a workbook with several sheets. I have this formula in one sheet that is supposed to pull info form the other two worksheets and return a specific value to the cell. =IF(OR($A8='Paper-Direct'!$A$1:$A$31), "8120", IF(OR($A8='2020_Order_Guide_61233698_10072'!$A$1:$A$500),"8020", 0)), All it is doing is returning "0". it use to work great. I don't know what the issue is? HELP
Perhaps this:
=IF(ISNUMBER(MATCH($A8,'Paper-Direct'!$A$1:$A$31,0)), "8120", IF(ISNUMBER(MATCH($A8,'2020_Order_Guide_61233698_10072'!$A$1:$A$500,0)),"8020", 0))
Perhaps this:
=IF(ISNUMBER(MATCH($A8,'Paper-Direct'!$A$1:$A$31,0)), "8120", IF(ISNUMBER(MATCH($A8,'2020_Order_Guide_61233698_10072'!$A$1:$A$500,0)),"8020", 0))- Thank you 🙂 that worked great.
- You're welcome!
