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.)

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.)