Vlookup using letter and numeric codes

Giganews Newsgroups
Subject: Vlookup using letter and numeric codes
Posted by:  LW_Greeney
Date: Mon, 22 May 2006

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

Replies