For instance the Sales Order # from the Explore Sales Orders and the Sales order # from Explore Sales Lines give an #N/A result from the MATCH function, even though visually the data in the Excel cells is exactly the same. I get around this by using MID function to pull out the last 5 real digits of the sales order # (eliminating leading (5) 0s (we are on order 84xxx) and "-SO", and ) from both exports. Even then the # won't process in the MATCH function correctly. I further have to multiply all the sales order #s by "1". Then they will MATCH!

by: DAVID G. | over a year ago | 4 - Reports / BI