It looks like the vlookups on your Customer Service Timesheet are set up
incorrectly. You have them looking for the person's name in column A,
C, E, etc on the Customer Service Roster tab. The problem is that the
names are in columns B, D, F, etc (i.e. the right hand column rather
than the lefthand column). To get it to work correctly, you can either
switch the columns on the Customer Service Roster tab (since the looked
up value always has the be in the left most column) or you can use and
Index/Match combo function and leave the columns as-is. If others are
going to work with this spreadsheet, the vlookup is probably the way to
go since most people are familiar with this function - and Index/Match
may confuse them otherwise. Let me know if you need more help, Chad


--
cvolkert
------------------------------------------------------------------------
cvolkert's Profile: http://www.excelforum.com/member.php...o&userid=24380
View this thread: http://www.excelforum.com/showthread...hreadid=488959