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'!...
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!
