| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
MS Works Spreadsheet 2000 v5.0 VLOOKUP
My VLOOKUP does not appear to work correctly. Given the following:
AI AJ VLOOKUP("Chores",AI2:AI6,0) = "Chores" as expected 2 "Chores 8 but VLOOKUP("Chores",AI2:AI6,1) = ERR 3 "Fun 4 4 "Sleep 8 5 "Meals 2.5 6 "Service 3.0 Any insight or advice would be appreciated. (By the way, this VLOOKUP only takes 3 parameters.) |
|
#2
|
|||
|
|||
|
You might try VLOOKUP("Chores",AI2:AJ6,1) or ask in the Works
newsgroup at http://www.microsoft.com/communities...ang=en &cr=US .. John L. wrote: My VLOOKUP does not appear to work correctly. Given the following: AI AJ VLOOKUP("Chores",AI2:AI6,0) = "Chores" as expected 2 "Chores 8 but VLOOKUP("Chores",AI2:AI6,1) = ERR 3 "Fun 4 4 "Sleep 8 5 "Meals 2.5 6 "Service 3.0 Any insight or advice would be appreciated. (By the way, this VLOOKUP only takes 3 parameters.) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Save As... MS Works 2000 spreadsheet | Excel Discussion (Misc queries) | |||
| excel 2000 spreadsheet | New Users to Excel | |||
| Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
| Merge two Excel 2000 spreadsheets | Excel Discussion (Misc queries) | |||
Linear Mode
