View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
LW_Greeney
 
Posts: n/a
Default 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