joestr8edg
New Member
- Joined
- Mar 16, 2009
- Messages
- 2
I am trying to match data from a customer to data dumped from my ERP. My vlookup fromula returns the value #N/A for records I know should work.
I have tried the recomended microsoft fix (place a 1 formatted as general in an empty cell and then use the multiply option from paste special). This does not work.
The funny thing is, if I re-key the lookup_value manually, the formula returns the value I am looking for.
Anyone have an answer?
I have tried the recomended microsoft fix (place a 1 formatted as general in an empty cell and then use the multiply option from paste special). This does not work.
The funny thing is, if I re-key the lookup_value manually, the formula returns the value I am looking for.
Anyone have an answer?