Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup
When I run vlookup I get N/A. Also an error message saying "excel can't
complete task with availabe resources. Choose less data or close other applications." I tried closing my other applications and that didn't work. I'm almost positive my formula's correct. Any thoughts? =VLOOKUP(A2,'Master ZIP Code Cross-References 2005.xls'!$A$2:$C$30104,3,FALSE) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup
How much RAM do you have?
"Help with vlookup" wrote: When I run vlookup I get N/A. Also an error message saying "excel can't complete task with availabe resources. Choose less data or close other applications." I tried closing my other applications and that didn't work. I'm almost positive my formula's correct. Any thoughts? =VLOOKUP(A2,'Master ZIP Code Cross-References 2005.xls'!$A$2:$C$30104,3,FALSE) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup
You don't have a sheet reference in your xls file. I think you may have
to do something like: =VLOOKUP(A2,'[Master ZIP Code Cross-References 2005.xls]Sheet1'!$A$2:$C$30104,3,FALSE) assuming your table is in Sheet1 and that the file is in the current folder. Hope this helps. Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |