Vlookup using letter and numeric codes
I wonder if anyone can help me, I have got a spreadsheet where i want to
lookup product information using vlookup, but the problem i am having is that
becuase my product codes are both numeric and letter based it does'nt work
correctly.
I know if i use letter or numbers on there own it works fine but I would
like to use both, is there anyway to accomplish this?
Cheers
Alistaire
|