On the tab labeled AR Detail, I need to pull 1 of 2 cells into column S ( PO reference).
If there is a number in column M (Account Code 1)then use that number, however if is blank then use the data that is in column L (PO#).
I tried this formula but it didn't work .
I also need to add a trim function to it.
Solved by K. L. in 15 mins