L
LindaO
In a multi-tabbed workbook, we have product numbers (some with leading zeros
- some with alpha-numeric values) on one tab along with other product
information. On another tab, using a vLookup function that worked in Office
2000, the product numbers being typed in are not matching the product numbers
on the other tab. How can we resolve this? My product numbers must be
formatted as text to avoid dropping leading zeros.
- some with alpha-numeric values) on one tab along with other product
information. On another tab, using a vLookup function that worked in Office
2000, the product numbers being typed in are not matching the product numbers
on the other tab. How can we resolve this? My product numbers must be
formatted as text to avoid dropping leading zeros.