The same data field exported from two different Explorers does not immediately work with the Excel MATCH function. For instance the Sales Order # from the Explore Sales Orders and the 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 0s and "-SO", and we are on order 84xxx) 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!

Comments

  • Is it possible to have the data inherently work with the Excel MATCH function?