VLOOKUP
 

=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

VLOOKUP
 

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

VLOOKUP
 

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

VLOOKUP
 

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.