VLOOKUP

  • Thread starter Thread starter Kanmi
  • Start date Start date
K

Kanmi

=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
 
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
 
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
 
Back
Top