Either extend the table array, eg:
=VLOOKUP($B8,'WPS Detail Dates'!$B:$AZ,49,FALSE)
(assuming the col index: 49 is correct)

Or, re-examine whether the column index: 49 is correct?
If its supposed to be say: 39, then this should be ok:
=VLOOKUP($B8,'WPS Detail Dates'!$B:$AT,39,FALSE)
(assuming the table array: 'WPS Detail Dates'!$B:$AT is correct)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"Kanmi" wrote:
Thanks a lot for your time. please can you explain more what to do.