VLOOKUP returns N/A even though I can see the value on the other sheet Formula Help
Lookup value is an order number like 100234, sitting in column A on both sheets. returns N/A for about a third of the rows and works perfectly for the rest. If I copy the value from one sheet and paste it into the…