| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Linear Mode
