Hi Howard,

Am Fri, 12 Jul 2013 11:31:09 -0700 (PDT) schrieb :

=VLOOKUP(--LEFT(A2,1),A4:P9,{2,3,15,16},0)
=VLOOKUP(--RIGHT(A2,1),A4:P9,{2,3,15,16},0)

what do your want to do?
Select 4 cells and try:
=VLOOKUP(INT(A2),A4:P9,{2,3,15,16},0)&"/"&VLOOKUP(--RIGHT(A2,1),A4:P9,{2,3,15,16},0)


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2