Thanks alot for your time. please can you explain more what to do.

"Max" wrote:

Your return from col: 49
exceeds the number of cols straddled in your table_array:
'WPS Detail Dates'!$B:$AT
since cols B to AT = 45 cols only

Fix one or the other of the above params,
and it should work ok

aloha? punch it, click the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"Kanmi" wrote:
=VLOOKUP($B8,'WPS Detail Dates'!$B:$AT,49,FALSE) pls why is formular showing
#REF!. Please can anybody help me with this. Appreciate your time. Thanks