Sorry the code i was meant to post looks like this maybe that would mak
a difference to the formula, althought i have tried modifying the code
all i seem to get is a "#VALUE" insert into the cell/s i run the macr
on...

=IF(LEFT('Master Roster'!$C3,2)="RN",VLOOKUP('Maste
Roster'!$E3,RN_shiftcode_table,3,FALSE),IF(LEFT('M aste
Roster'!$C3,2)="EN",VLOOKUP('Maste
Roster'!$E3,EN_shiftcode_table,3,FALSE),IF(LEFT('M aste
Roster'!$C3,2)="PC",VLOOKUP('Maste
Roster'!$E3,PCW_shiftcode_table,3,FALSE),IF(LEFT(' Maste
Roster'!$C3,1)="D",VLOOKUP('Maste
Roster'!$E3,DON_shiftcode_table,3,FALSE),IF(LEFT(' Maste
Roster'!$C3,2)="TH",VLOOKUP('Maste
Roster'!$E3,TH_shiftcode_table,3,FALSE),"USC"))))

--
Message posted from http://www.ExcelForum.com