S
ShagNasty
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 0’s 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 haven’t had much luck except to get error or
value messages. Please help..
JCodes and Col B2:B65 = JDesc. Job Code is a “general†field with JCodes
formatted as 004455, 000333, etc. (two leading 0’s 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 haven’t had much luck except to get error or
value messages. Please help..