I'd use a function within the MATCH to force your 4-digit code to match the
codes in your table... So if your table's codes are 6-digit text strings,
then instead of matching A13, I'd match "00" & A13. (I'm guessing that the
codes are six digits of text, rather than numbers formatted as "000000", or
you probably wouldn't be having an issue).
Also, if the 'key value' you're looking up is in colum A and the value
you're returning in column B, you could use a vlookup rather than
index/match:
=vlookup("00"&A13,JobCodes!$A$2:$B$65,2,0)

"ShagNasty" wrote:

I have a spreadsheet worksheet used as €œlookup€� table where Col A2:A65 =
JCodes and Col B2:B65 = JDesc. Job Code is a €œgeneral€� field with JCodes
formatted as 004455, 000333, etc. (two leading 0s with each JCode). On
another worksheet I enter the JCode to get the JDesc using the six character
JCode (=INDEX(JobCodes!$B$2:$B$65,MATCH(A13,JobCodes!$A$ 2:$A$65,0)). I want
to use just the last 4 characters to return the JDesc (maybe using the
€œright()€� function). Anywho, I havent had much luck except to get error or
value messages. Please help..