Hello,
In need of assistance with advancing or changing my current excel formula.
'm using an IFERROR function and coming up with a bank which is a true result based on the data.
However, how can I add to my formula to view another cell and return the left five values from that data description?
Current formula: =IFERROR(INDEX('My Project Data'!$I$2:$I$71659,MATCH($D2,'My Project Data'!$J$2:$J$71659,0)),"NO Order")
(if the result is a blank in "C3" of Purchase Order tab, can a formula look at cell E3 and bring over the first 5 numbers of that text description)
Answer would be: 89054.
Thank you!!!!!
Bookmarks